Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Percentile calculation for each value in a data set.

Hi All,   I have a request to show the percentile for each value in the the table. Here, I am not talking about what is 80th percentile in the given set of numbers, but actually the opposite, what ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you both for looking into this.

 

I replicated the formula and its not giving me the correct answer.

For example : 

 

below in the pic, its showing

Percentile 50 which is a measure with formula  "PERCENTILE 50 = PERCENTILEX.INC (table1,table1[Rate],0.5) "

and the Rank/Total = RANKX (ALL (Query1),

CALCULATE ( AVERAGE( table1[Rate] ) ), , ASC, SKIP) / COUNTX ( ALL ( table1 ), table1[city])

 

 

Per my understanding, i should be getting less than 50.74% for the Average value of $63.44

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    May i request you to respond on this please please...

    • v-lionel-msft's avatar
      v-lionel-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Anonymous ,

       

      Has your problem been solved?

       

      Best regards,
      Lionel Chen

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.