Countries Item sales ranking

[Young_G_Han]

  Dear Sir

I need a measure that can show a ranking of each product.

But it is not a normal ranking.

For example,

Country     Product     Q'ty

Korea         A               10

Korea         B                 5

Japan         A                 5

Japan         B                 3

China         A                 3

China         B                10

I would like to show a table that is showing the ranking of each product like below...

Country       Product      Ranking

Korea           A                1

Korea           B                2

Japan           A                2                

Japan           B                3

China           A                3

China           B                1

How can I make the ranking measure? Is it possible?

Please help.

[mlsx4 · Accepted solution]

Hi @Young_G_Han 

Rank = 
RANKX(
ALL(MyTable),
CALCULATE(SUM(MyTable[Qty])),,DESC, Dense)

[Young_G_Han]

Dear mlsx4

Thank you. Due to the size of the table is huge, I could not use the same measure, but your All(MyTable) idea helped me to make a new measure and it is working.

Thank you so much.

[mlsx4]

I'm glad you could finally solve it!! 😉

You're welcome