Finding Top or Bottom N Percent using DAX

[Anonymous]

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 

[amitchandak]

@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]))

Example - https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

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/