Ranking Equal Values based on alternative parameters

DAX DAX Calculations
3

@Anferrig,

Here’s how I do this:

  1. do a RANKX of your secondary criteria first, but make sure you ASC as the sort order, so the best performer gets the highest rank, not a rank of 1

  2. CONCATENATE your primary metric (in this case points) with the result of the reverse RANKX above using “.” as your delimiter. For example, Juventus would get a value of 90.20 (90 goals, and the 20th reverse ranking in 1). Be sure to wrap your CONCATENATE statement in a VALUE() function so that it returns a number

  3. now do your primary RANKX on the values created in 2) above. This will properly separate out ties in points based on the secondary criteria, unless for the tied point values the secondary criteria are also tied. In that case, you can add in a second tie-breaking criteria and concatenate that onto the value created in 2) above.

I hope that makes sense. If you have any problems, please just post your PBIX and we can work through the specific DAX.

  • Brian
1 Like