Help with a calculated column ranking

[bovkurka]

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 insight into what I'm doing wrong.

I need to rank a column of point values for users who are earning points in an incentive program. I am summing up their point total using a simple measure (form a table called "JDIIdeas" and a column called "Previous Month Points") in a different table called "Participants".

Previous Month Total Points = sum(JDIIdeas[Previous Month Points]).

This produces (in the Participants table):

I am then adding in the following ranking formula in a new column in the Participants table (this isn't my own formula, I found it on the internet so I'm not sure it's the right way to do it):

Previous Month Rank =

var a = RANKX(Participants,Participants[Previous Month Total Points])

RETURN

a

I then get this result in the Participants table:

The problem is that the ranking is skipping numbers and I'm not sure how to fix it. I want the output to be:

My BI knowledge is limited and while I believe the issue is related to using RANKX (and not using it properly for this situation), I do not know what other methods can work to do this. 

Thanks

[tackytechtom · Accepted solution]

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]

Tom - thank you! worked perfectly!