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://rad...
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

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