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.

     

     

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

Thanks, it worked! but I have a column which filter internations and domestic routs and another one which filters departure and arrival, when I apply it show the rank of international for example it miss up the rank and goes 7 10 30 etc.

can I make the rank dynamicly to when I apply filters.

 

Thanks

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

In that case, you need to go for Measure in place of calculated column.

 

Create measure - 

TotalPaxMeasure = Sum('Table'[Total Pax No.])

 

Create one more measure after creating above one and then use it for ranking.

 

RankMeasure =
CALCULATE (
    RANKX ( ALLSELECTED ( 'Table'[Routes] ), [TotalPaxMeasure],, DESC, DENSE )
)

 

Please mark it as answer if it resolves your issue. kudos are also appreciated.