Can I get dynamic Unique Rank on the basis of 3 measure sorting in table visual?

[Anonymous]

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?

[Anonymous]

Can anyone please help on above issue?

[v-kelly-msft · Accepted 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!

[Anonymous]

Thankyou so much for the help! this works 🙂