BenchMark Quizzes by MDFT Pro

Resolve Percentile Calculation Errors In Power BI

You use the PERCENTILEX.EXC function in a measure to calculate the 95th percentile for sales in a Power BI report at MDFT Pro. The academy wants to identify top-performing sales but encounters an error in the visualization due to too few values in the range.

How should you resolve the error and show the 95th percentile in your report?

Choose the correct answer from the options below.

Explanations for each answer:

Replace the function with the PERCENTILEX.INC function. is correct. PERCENTILEX.INC works for any value of k between 0 and 1, even with few values in the range.
Replace the function with the PERCENTILE.EXC function. is incorrect. PERCENTILE.EXC has the same limitations as PERCENTILEX.EXC and will error with too few values.
Use binning and add 20 bins to the value column. is incorrect. Binning does not resolve the issue of too few values for percentile calculation.
Add a forecast to the visualization at 95% confidence level. is incorrect. Adding a forecast does not resolve percentile calculation errors.

Learn more about PERCENTILEX.INC in Power BI:

Power BI Percentile Functions

Exam Preparation Quiz

Resolve Percentile Calculation Errors In Power BI