Create ranking horizontally

[Carly_717]

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.

[bhanu_gautam · Accepted solution]

@Carly_717 , Try using 

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