Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Ranking based on condition

Is it possible to rank based on conditions? For example I have list of tickets with Assigned to. If Assigned to is not blank only then the Rank should be assigned based on Ticketnumber (string).   ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    Please create a calculated column using below formula:

    Rank =
IF (
    Table1[Assigned To] = BLANK (),
    BLANK (),
    RANKX (
        FILTER ( Table1, Table1[Assigned To] <> BLANK () ),
        VALUE ( RIGHT ( Table1[TicketNumber], 1 ) ),
        ,
        ASC,
        DENSE
    )
)

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

Please create a calculated column using below formula:

Rank =
IF (
    Table1[Assigned To] = BLANK (),
    BLANK (),
    RANKX (
        FILTER ( Table1, Table1[Assigned To] <> BLANK () ),
        VALUE ( RIGHT ( Table1[TicketNumber], 1 ) ),
        ,
        ASC,
        DENSE
    )
)

Best regards,
Yuliana Gu