Classification based on 7 criteria

[Anonymous]

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:

• First: Who has the most points?
• Second: Who has the most points in Phase 4
• Third: Who has the most points in Phase 3
• Fourth: Who has the most points in Phase 2
• Fifth: Who has the most points in Phase 1
• Sixth: Who has the most progression%
• Seventh: Who has concluded first.

Does anyone know if it is possible to deal with this complex scenario?

Thank you all.

[v-lili6-msft · Accepted 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