Forum Discussion

RexaZii93's avatar
RexaZii93
Icon for Helper I rankHelper I
4 years ago
Solved

How to create ranking for highest value to lowest

Hi   I want to create a rank by highest value, for example if I have this table:   Routes: Total Pax No.: RUH 10,000 JED 6,000 RUH 15,000 ABH 9,000 JED 7,000   I want...
Need Help
  • Shishir22's avatar
    Shishir22
    4 years ago

    Hello RexaZii93 ,

     

    Try creating below calculated column- 

    Rank =
RANKX (
    'Table',
    CALCULATE (
        SUM ( 'Table'[Total Pax No.] ),
        FILTER ( 'Table', 'Table'[Routes] = EARLIER ( 'Table'[Routes] ) )
    ),
    ,
    DESC,
    DENSE
)

     

     

    Please mark it as solution if it solves your issue. Kudos are also appreciated.

     

     

Shishir22's avatar
Shishir22
Icon for Solution Sage rankSolution Sage
4 years ago

Just use rank measure as visual level filter and set to equal to 1.

 

RexaZii93's avatar
RexaZii93
Icon for Helper I rankHelper I
4 years ago

Thanks I tested to a list visual and it worked I can just change the number to any rank and it shows the data I want, but when I use a card visual  and applied the measure it grays out do you know why is that and how to fix it?