Forum Discussion
RANKING
Hi Everyone, Need your assistance on this.
I'm trying to work on a RANKX function. Looking at the below tables, the first Table is the main data source, but what I'm trying to achieve is the 2nd table (by Cashier) and 3rd table (by Ranking) basing on the Total Points of 2nd table (by Cashier).
Any help is much appreciated. Thank you!
Anonymous solution is attached, I created a dummy data and it is under Table.
The core solution here is to unpivot the data in Power Query and then add Rank measure and visualize it.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.⚡
