Rank/ TOPN based on two columns

[kk_shp_user]

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.

[kk_shp_user · Accepted solution]

I was able to solve this using ROWNUMBER()

[v-zhengdxu-msft]

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.