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
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi  th3h0bb5,

 

As I know, the PERCENTILE.INC() function has a little different from Percentile line in Analytics pane.

 

The fucntion is calculated for each row of a table and the Percentile line is used for analysis the chart.

 

Best Regards,

Cherry

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

    Hi Cherry,

     

    But how exactly would that impact the final results? The Tabular view has Car | Max Speed | Calculation. The Visualization has Car | Max Speed | Calculation. If the input is the same, what is PowerBI doing that causes it to produce different results?

     

    Cheers,


    Hobbs

    • v-piga-msft's avatar
      v-piga-msft
      Icon for Resident Rockstar rankResident Rockstar
      8 years ago

      Hi th3h0bb5,

       

      Sorry for the previous reply. 

       

      By my tests again on the version Power BI Desktop 2.60.5169.3201 64-bit (July 2018), it seems that the value of PERCENTILE.INC() is the same with the value of Percentile Line.

       

       

      You could have a reference of my attachment.

       

      Best Regards,

      Cherry

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

        Hmm. Interesting. I wonder if perhaps it's something in my data that is causing the issue. Perhaps one handles NULLS differently than the other?