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. ...
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
    )

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
)