cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

 

SRikanth15_0-1669364649288.png

 

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 ?

Status: Investigating

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

 

Comments
v-caitlyn-mstf
Community Support
Status changed to: Investigating

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