Forum Discussion

MichaelJSpence's avatar
MichaelJSpence
New Member
3 years ago
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 ...
Need Help
  • nandukrishnavs's avatar
    nandukrishnavs
    3 years ago

    MichaelJSpence  Try this

     

    Column =
RANKX ( 'Challenge', 'Challenge'[Person A Score],, ASC, SKIP )
nandukrishnavs's avatar
nandukrishnavs
Community Champion
3 years ago

MichaelJSpence  Try this

 

Column =
RANKX ( 'Challenge', 'Challenge'[Person A Score],, ASC, SKIP )
MichaelJSpence's avatar
MichaelJSpence
New Member
3 years ago

That worked, thankyou so much!