Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
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
Solved! Go to Solution.
That worked, thankyou so much!
User | Count |
---|---|
77 | |
74 | |
60 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |