Forum Discussion

bovkurka's avatar
bovkurka
New Member
4 years ago
Solved

Help with a calculated column ranking

Hello, I've searched through nearly every post I could to try and solve this before posting, but none of the solutions have worked for me and I'm not sure why - hoping someone can give me some insigh...
tackytechtom's avatar
tackytechtom
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Hi bovkurka ,

 

Is it this you are looking for? 🙂

 

Here the DAX:

Previous Month Rank = 
var a = 
RANKX ( 
    Table4,
    Table4[Previous Month Total Points],
    , DESC
    , DENSE
    )
RETURN
a

It is the DENSE attribute, which is doing the trick. Let me know if this helps! 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

  • bovkurka's avatar
    bovkurka
    New Member
    4 years ago

    Tom - thank you! worked perfectly!