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.⚡
7 Replies
Anonymous can you put the data in a pbix file and share using one drive/google drive.
Anonymous can you also share data.xlsx file used in the report? It requires some transformation and for that, I need the raw xlsx file.
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.⚡
Hi parry2k , Can't open the pbix file, it is incompatible. I'm using April 2021 version.
Anonymous you need to upgrade your power bi desktop to the latest version (i cannot downgrade).