Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Classification based on 7 criteria

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:

UseridPointsPhase4PointsPhase3PointsPhase2PointsPhase1Points% ProgressConclusiónFecha
9277999740029720010010010/01/2020 07:58:52
209429954002972009895,6503/01/2020 07:58:15
2674499440029420010095,6522/01/2020 23:18:57
4123898939229720010095,6509/01/2020 15:34:56
8795598740029719010095,6527/12/2019 13:45:46
15645998740029719010095,6526/12/2019 17:20:45
10677298740029719010095,6519/12/2019 20:28:55
648898740029719010010009/01/2020 17:03:38
120369844002912009395,6531/12/2019 12:27:33
2291849844002912009395,6524/12/2019 21:39:03
6475598440029419010095,6524/12/2019 09:55:48
545699844002942009097,8319/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.

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    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

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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