Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I filtered my table visual as per below:
1. Sort by Largest o smallest - Ratio
2. Sort by Largest to smallest - Shipped- Issues
3. Sort by smallest to largest - Orders received
Now I want a dynamic ranking within all the groups and within product groups.
Dynamic ranking as in attached image and within group (say product C) it should state as 1, 2,3,4 when i filter on group level (on the basis of sorting)
If I filter on group level, it should be like below
Can anyone help me up please?
Solved! Go to Solution.
Hi @Anonymous ,
Create 2 measures as below:
Measure =
var _rankbyratio=RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[Ratio])),,DESC,Dense)
var _rankbyShippedIssues=RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[Shipped-Issue])),,DESC,Dense)
VAR _rankbyorder=RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[Orders Recd])),,ASC,Dense)
Return
_rankbyorder+_rankbyratio+_rankbyShippedIssues
Ranking = RANKX(ALLSELECTED('Table'),'Table'[Measure],,ASC,Dense)
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Can anyone please help on above issue?
Hi @Anonymous ,
Create 2 measures as below:
Measure =
var _rankbyratio=RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[Ratio])),,DESC,Dense)
var _rankbyShippedIssues=RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[Shipped-Issue])),,DESC,Dense)
VAR _rankbyorder=RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[Orders Recd])),,ASC,Dense)
Return
_rankbyorder+_rankbyratio+_rankbyShippedIssues
Ranking = RANKX(ALLSELECTED('Table'),'Table'[Measure],,ASC,Dense)
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Thankyou so much for the help! this works 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.