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 ?
Comments
- Codehustler on: Automation of exporting power bi report to a share...
-
emarshall
on:
Unable to feed on-premises SQL-Server data into La...
-
emarshall
on:
Data Marts Not Working
-
v-yetao1-msft
on:
Alt Key Shortcuts Causing Problems
-
v-xiaoyan-msft
on:
A typo in the Quick measure
-
v-yetao1-msft
on:
Serious BUG of PBI Desktop May 2023 release
-
v-xiaoyan-msft
on:
Error when using search in a slicer widget.
- aJayMitchell on: Ambigious path error in Direct Query dataset, but ...
-
v-xiaoyan-msft
on:
Reports do not refresh
-
v-yetao1-msft
on:
Power Bi desktop File Error
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