Forum Discussion
Finding Top or Bottom N Percent using DAX
Hi,
I am trying to obtain the top n percent of customers such as the example given in
https://www.burningsuit.co.uk/blog/2019/05/find-top-or-bottom-n-percent-dax/
However, I can't do it with my own file with the top/bottom percent. Please kindly help
1 Reply
- amitchandak
Super User
Anonymous , if you are looking for TOPN or bottomN, then you need to have formula like
Top Rank = CALCULATE([Total Trans Amount],TOPN(selectedvalue(TopBottom[TopBottom]),all(Table[Customer]),[Sales],DESC),VALUES(Table[Customer]))
If you need Top percent
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/
