Add 2nd Measure to Top 5 Matrix

[Anonymous]

Top 5 Plan Level By Total Cost = 
VAR _Rank = RANKX( ALL( 'Database'[Plan Level] ), [Total Cost], , DESC )

RETURN
IF( _Rank <= 5, [Total Cost], BLANK() )

I have the above DAX to Calculate the Top 5 Total Cost at Plan Level

I would like to add a 2nd measure that shows just for these Top 5 values

When I bring the measure in it shows the % Value for all Plan Levels

And if I write an equivalent measure for the % this calculate the top 5 for that measure which isn't what I want

Can this be done at all?

Hope it makes sense! And thanks in Advance!

[v-yalanwu-msft · Accepted solution]

Hi,  @Anonymous ；

You could add filter or create a measure.

Method1:

Method2:

%per = IF([Top 5 Plan Level By Total Cost]<>BLANK(), DIVIDE([Total Cost],CALCULATE([Total Cost],ALL(Database))))

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.