Forum Discussion

nutmegs's avatar
nutmegs
New Member
5 years ago
Solved

Rank with multiple fields

I have a ranking problem.  I need to rank results by alias, ordered by orderid Positive Result Reporting Table = SUMMARIZE( Data_File, Data_File[RESULT ], Data_File[ALIAS ], Data_File[ORDERID ],...
Need Help
  • smpa01's avatar
    smpa01
    5 years ago

    nutmegsnot sure if you want a calculated column or a measure, so did both.

    Column =
RANKX (
    FILTER ( ranking, EARLIER ( ranking[ALIAS] ) = ranking[ALIAS] ),
    ranking[ORDERID],
    ,
    ASC
)

Measure:= 
RANKX (
    FILTER ( ALLSELECTED ( ranking ), ranking[ALIAS] = MAX ( ranking[ALIAS] ) ),
    CALCULATE ( MAX ( ranking[ORDERID] ) ),
    ,
    ASC
)

     

     

     

  • smpa01's avatar
    smpa01
    5 years ago

    nutmegs 

    Measure = 
RANKX (
    FILTER (
        ALLSELECTED ( 'rank' ),
        'rank'[ALIAS] = MAX ( 'rank'[ALIAS] )
            && 'rank'[TestDate] = MAX ( 'rank'[TestDate] )
    ),
    CALCULATE ( MAX ( 'rank'[ORDERID] ) ),
    ,
    ASC
)
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi nutmegs ,

You can create a measure as below:

Test Order =
RANKX (
    ALLEXCEPT ( 'Data_File', 'Data_File'[ALIAS] ),
    CALCULATE ( MAX ( 'Data_File'[ORDERID] ) ),
    ,
    DESC,
    DENSE
)

Best Regards