Forum Discussion
Breaking ties in RANKX
I'm using the rank function and would like to basically assign a row number insted of a rank, to give a distinct rank instead of duplicate rankings for a tie.
I currently have
Department Count Rank What I would like for the rank
A 11 1 1
B 10 2 2
C 10 2 3
D 5 4 4
E 3 5 5
F 3 5 6
Any help is appreciated.
6 Replies
- CNENFRNLCommunity Champion
- parry2kSuper User
ABMN check at the bottom of this blog post (section called breaking ties) and see if that helps How to use RANKX in DAX (Part 2 of 3 – Calculated Measures) - RADACAD
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort 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.