Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 Calcu...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

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.