Forum Discussion

th3h0bb5's avatar
th3h0bb5
Icon for Resolver II rankResolver II
8 years ago

Percentile varies between DAX and Reference Line?

I have data about how fast cars are going. I want to show the 99th Percentile of max speed. I've done this two ways. In DAX with the PERCENTILE.INC() formula:   And with an Analysis reference...
Need Help
williamdlupo's avatar
williamdlupo
Frequent Visitor
7 years ago

Hello Cherry

 

Unfortunately no this is not a solution. I have tested the Percentile.Inc and Percentile.Exc DAX functions against a set of data and neither of the values returned match the Percentile (or Median) analytical line values. It appears the analytical line values are being calculated in some way because the values returned are not in the background data set.

 

I'm more than happy to share screen shots of my charts as well as my DAX function return values. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I am seeing the same behavior in a scatter chart.  I created measures using both PERCENTILE.EXC and PERCENTILE.INC for P10, P50 and P90.  I also applied the same percentage lines to the scatter chart, which sometimes match and sometimes do not.  The "Filter and slicers affecting this visual" are the same in both the scatter chart and cards containing the measure.  This does not make sense and certainly is an issue if trying to show the P-values to users while also plotting a line on the chart that doesn't align.