Ranking score by user over month

[JamesBx]

Hi All, another new user here.

As the title suggests I have this concept of a league table where we are trying to rank users by a score.

I have 3 tables, uVw_New_Journeys which relates to a users table through user id and a dimensional table that relates to a date field.

I'm trying to get a ranking based on the months selected by user and their score.  The following DAX I have scratched around at to see if I can get it working but I cannot:

Rank = RANKX(ALL('users'[Name]),CALCULATE(SUM(uVw_New_Jouneys[total_score])),,DESC,Dense)

From this, I can't even get just a straight ranking that then leads onto the second part of this.  The ranking gives some strange results, even for months that don't exist.

If these scores tie, we would like to then start taking into account additional columns, we call infractions, that will tie break these for instance:

Name	Rank	Score	Speeding
Test1	1	98	100
Test5	2	90	90
Test3	3	90	80
Test7	4	90	70
Test2	5	88	90
Test4	6	86	88
Test6	7	82	90

Any help would be greatly appreciated.

[amitchandak]

@JamesBx , Check how to break ties using another column

https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/

Also, check

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

[JamesBx]

So turns out I was using the wrong column for the rankx, I also changed it to allselected for the user which has gotten me to the first hurdle.  After bashing my head for a little while on this, i guess I just needed a little break and to look at it again to fix these rather obvious issues.  Not sure how I go about adding in additional columns now though.

I am now at:

Rank = RANKX(ALLSELECTED('users'[Name]),CALCULATE(uVw_New_Jouneys[Weighted Score]),,DESC,Dense)

[az38]

Hi @JamesBx 

check this great article https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

[JamesBx]

Thank you, so if im reading this correct, here they are using add function to add the values together, i have tried this, but its not quite correct as the two values could add up to more that a lower rank.  It almost needs to be a waterfall approach.  Is the divide by 10000 doing this function that is described as a "technique" in this article?  To quote:

"The additional code is line 10, which extends the <expression> using a technique that makes the result of each <expression> unique without upsetting the initial sort order."

[mahoneypat]

Here is one way to write this measure using the sample data you provided.

RankUsers = RANKX(ALL(Users[Name]), CALCULATE(SUMX(Users, Users[Score]+Users[Speeding]/1000)),,DESC,Dense)

Here is what it returns in a table visual.

If this solution works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.
Regards,
Pat