Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Create ranking horizontally

Hi, 

I would like to create a measure in pbi to get the ranking horizontally.

For Example, the below are the sales.

I would like to create a meausure to get the ranking for country.

Thanks in advance everyone.




Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    Anonymous , Try using 

    Country Sales Rank =
    RANKX(
    ALL('Sales'[Country]),
    CALCULATE(SUM('Sales'[SalesAmount])),
    ,
    DESC,
    Dense
    )

1 Reply

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    1 year ago

    Anonymous , Try using 

    Country Sales Rank =
    RANKX(
    ALL('Sales'[Country]),
    CALCULATE(SUM('Sales'[SalesAmount])),
    ,
    DESC,
    Dense
    )