create rank for each category

[Anonymous]

Hi All,

Below is my sample data,

I have to create rank (measure) for brands based on Sale amount for each category using matrix visual.

Brand name as row, category as column, sale amount & rank as values in matrix visual.

Ex:

Thanks...

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the below picture and the sample pbix file's link down below.

Sale Amount =

SUM(Data[Sales Amount])

Rank =

RANKX(ALLSELECTED(Data[Brand Name]), [Sale Amount],,DESC)

https://www.dropbox.com/s/cdwaoi6unmf278k/rohini.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/