Forum Discussion
Solved
Dealing with ties in RANK
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
2 Replies
That worked, thankyou so much!
