Forum Discussion
bovkurka
4 years agoNew Member
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...
- 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 aIt 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/
tackytechtom
Most Valuable Professional
4 years agoHi 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
aIt 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/
- bovkurka4 years agoNew Member
Tom - thank you! worked perfectly!