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 line:

But they return different results! One is 198.72 and the other is 199.96

 

Why? I've tried .INC and .EXC for the DAX side, but neither matches the reference line.

 

 

Need Help

8 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident 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
      Resolver 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
        Resident 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