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 is the percentile of a particular value in the given set of numbers?
Any Idea how i can achieve this?
My data looks like below :
City : Area1, Area2, Area3, Area4, Area5, etc
Population : 954,213,816,549,80 etc
Desired output (percentile) : 95th, 20th, 80th Etc
6 Replies
- amitchandak
Super User
Anonymous ,
https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459
https://finance-bi.com/power-bi-pareto-analysis/
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/td-p/763156 - Greg_Deckler
Community Champion
Anonymous - Sounds like you want the PERCENTILE group of functions:
https://docs.microsoft.com/en-us/dax/percentile-inc-function-dax
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
