Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey, people.
I've been trying to create a report to a game in my company that show a rating based on 7 tiebreaker criteria.
I have read and tried to use the techniquies shown here https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns and other topics in the community, but I could not resolve it myself.
My data are:
Userid | Points | Phase4Points | Phase3Points | Phase2Points | Phase1Points | % Progress | ConclusiónFecha |
92779 | 997 | 400 | 297 | 200 | 100 | 100 | 10/01/2020 07:58:52 |
20942 | 995 | 400 | 297 | 200 | 98 | 95,65 | 03/01/2020 07:58:15 |
26744 | 994 | 400 | 294 | 200 | 100 | 95,65 | 22/01/2020 23:18:57 |
41238 | 989 | 392 | 297 | 200 | 100 | 95,65 | 09/01/2020 15:34:56 |
87955 | 987 | 400 | 297 | 190 | 100 | 95,65 | 27/12/2019 13:45:46 |
156459 | 987 | 400 | 297 | 190 | 100 | 95,65 | 26/12/2019 17:20:45 |
106772 | 987 | 400 | 297 | 190 | 100 | 95,65 | 19/12/2019 20:28:55 |
6488 | 987 | 400 | 297 | 190 | 100 | 100 | 09/01/2020 17:03:38 |
12036 | 984 | 400 | 291 | 200 | 93 | 95,65 | 31/12/2019 12:27:33 |
229184 | 984 | 400 | 291 | 200 | 93 | 95,65 | 24/12/2019 21:39:03 |
64755 | 984 | 400 | 294 | 190 | 100 | 95,65 | 24/12/2019 09:55:48 |
54569 | 984 | 400 | 294 | 200 | 90 | 97,83 | 19/12/2019 16:12:49 |
The tiebreaker criteria would be:
Does anyone know if it is possible to deal with this complex scenario?
Thank you all.
Solved! Go to Solution.
hi @Anonymous
Try to create a column as below:
Column =
RANKX (
'Table',
'Table'[Points] * 1000000000000 + 'Table'[Phase4Points] * 100000000000 + 'Table'[Phase3Points] * 100000000 + 'Table'[Phase2Points] * 1000000 + 'Table'[Phase1Points] * 10000 + 'Table'[% Progress] * 100
+ RANKX ( 'Table', 'Table'[ConclusiónFecha],, DESC ),
,
ASC
)
Regards,
Lin
hi @Anonymous
Try to create a column as below:
Column =
RANKX (
'Table',
'Table'[Points] * 1000000000000 + 'Table'[Phase4Points] * 100000000000 + 'Table'[Phase3Points] * 100000000 + 'Table'[Phase2Points] * 1000000 + 'Table'[Phase1Points] * 10000 + 'Table'[% Progress] * 100
+ RANKX ( 'Table', 'Table'[ConclusiónFecha],, DESC ),
,
ASC
)
Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |