Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a table like below and want to populate the rank column shown.
I want it to be based on count DESC, total DESC. I tried searching online on how to solve this without any success. This does not sound too complex but then I'm surprised there are not a bunch of questions around this.
Any help would be grteatly appreciated.
Solved! Go to Solution.
I was able to solve this using ROWNUMBER()
Hi @kk_shp_user
Congratulations!
I'm sure there are quite a few people who have been confused by this question.
Thank you very much for sharing.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |