how to rank the value based on category des order to asc by total amount

[SRikanth15]

Hi Team,

I'm not sure how to use the Rankx function by using two categories.

Please find the snip of the excel sheet where it has top 5 values by total descending order

How to get the similar view using dax in power bi and also want to rank them based on the total 

Could you please suggest ?

[v-xiaoyan-msft]

Hi @SRikanth15 ,

I can't click on the screenshot you provided properly, it looks TOO SMALL.

you can refer to these similar threads below, also, if you want better help on dax, DAX Commands and Tips - Microsoft Power BI Community  is the right forum.

RANKX and specifying ASC or DESC order - Microsoft Power BI Community

How to use the DAX RANKX function in Power BI - Databear

Solved: RANKX by category in Power BI - Microsoft Power BI Community

Best regards.
Community Support Team_ Caitlyn