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.

 

 

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

    Thanks I added the 2 measures but how does work? do I just add the pax no. and the rank measures to the filtering option?

    • 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?