Forum Discussion

th3h0bb5's avatar
th3h0bb5
Resolver 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
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi th3h0bb5,

 

Have you solved your problem?

 

If you have solved, could you please share the solution or always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If you still need help, could you share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

Best Regards,

Cherry

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.