Forum Discussion
Top Customers using RANKX and SUMX
psiripun , Can not say without looking at data. Please try like
Rank_Customer = RANKX(ALL(Customer[CustomerName]), [Sales_YTD ],,desc,dense)
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
psiripun I think this is what you need
Rank_Customer = RANKX(ALL(Customer[CustomerName]), [Sales_YTD]),,DESC, DENSE )change Ascending/Descending based on your need.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem.
It is a token of appreciation! ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Super Userpsiripun , Can not say without looking at data. Please try like
Rank_Customer = RANKX(ALL(Customer[CustomerName]), [Sales_YTD ],,desc,dense)
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
- parry2k
psiripun I think this is what you need
Rank_Customer = RANKX(ALL(Customer[CustomerName]), [Sales_YTD]),,DESC, DENSE )change Ascending/Descending based on your need.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem.
It is a token of appreciation! ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡