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
-
v-xiaoyan-msft
on:
Incorrect value shows in table, and duplicate row ...
-
v-xiaoyan-msft
on:
Fix Dataflow Gen1 Referenced Entities in Downstrea...
-
v-xiaoyan-msft
on:
Issue on MAP visual
-
v-xiaoyan-msft
on:
Failed to update Source Credentials PBi Service
- Damiensize on: Lakehouse table error : Encountered Azure error wh...
- ku_kim on: Connect Partitioned table in Fabric Lakehouse to P...
-
v-xiaoyan-msft
on:
Issue: unable to load word cloud
- tolsond on: Power Bi Mark as Date Table issue after November 2...
- Giangnt on: Can't refesh Data in PBI
-
v-xiaoyan-msft
on:
Access to ADO ODATA Feed from PowerBI is fails fro...
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