Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.

SRikanth15

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

Submitted by on ‎11-25-2022 12:26 AM

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
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎11-27-2022 10:13 PM

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

 

Idea Statuses