topic Re: Rank/ TOPN based on two columns in DAX Commands and Tips

Rank/ TOPN based on two columns

kk_shp_user — Thu, 11 Apr 2024 11:48:15 GMT

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.

Re: Rank/ TOPN based on two columns

kk_shp_user — Thu, 11 Apr 2024 14:43:37 GMT

I was able to solve this using ROWNUMBER()

Re: Rank/ TOPN based on two columns

Anonymous — Tue, 16 Apr 2024 02:52:42 GMT

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.