Forum Discussion
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 ...
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
May i request you to respond on this please please...