Dealing with ties in RANK

[MichaelJSpence]

So I'm trying to add a couple of calculated columns with the Rank function in DAX but I'm having trouble getting it to work properly and skip after ties. I want to do other calculations based on the results, so it needs to be a column, rather than a measure.

Below is the formula and output.

RANK(SKIP,,ORDERBY('Challenge'[Person A Score], desc),LAST,,)

The order is correct, but the problem I have are ties. After ties I want the number to skip, so in the example above the attributes currently ranked 5 would be ranked 8. The below is what I'd want the above output to actually look like. Any help would be greatly appreciated!

1

2

3

4

4

4

4

8

8

8

8

8

13

13

15

15

17

18

[nandukrishnavs · Accepted solution]

@MichaelJSpence  Try this

Column =
RANKX ( 'Challenge', 'Challenge'[Person A Score],, ASC, SKIP )

[MichaelJSpence]

That worked, thankyou so much!