Forum Discussion
Add 2nd Measure to Top 5 Matrix
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!
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.
1 Reply
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.