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 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

2 Replies