Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

RANKX Help

I am trying to create a measure to create a ranked column for a table.   Table Name: vCallBackBC (See image below for columns)   The rank will be determined in order by the data in the following ...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
5 years ago

Hi, Anonymous ;

You could modify the mesaure as follows:

Measure = RANKX(ALL(vCallBackBC),CALCULATE(MAX([Cycle])),,DESC)

If you want to base it on three columns, try it:

BC Rank =
RANKX (
    ALL ( vCallBackBC ),
    RANKX ( ALL ( vCallBackBC ), CALCULATE ( MAX ( [Cycle] ) ),, DESC ) * 10000
        + RANKX ( ALL ( vCallBackBC ), CALCULATE ( MAX ( [Hire Date] ) ),, DESC ) * 100
        + RANKX ( ALL ( vCallBackBC ), CALCULATE ( MAX ( [Name] ) ),, DESC ),
    ,
    ASC
)

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.