Top 5 for each month

Hi Anonymous 

One way:

create  two measures for each type, for example for "% Processor Time", then add one measure in the visual level filter as below:

Processor_value = CALCULATE(SUM('Table 2'[value]),FILTER('Table 2','Table 2'[name]="% Processor Time"))

Processor_rank = RANKX(FILTER(ALLSELECTED('Table 2'),'Table 2'[name]="% Processor Time"&&'Table 2'[monthyear]=MAX('Table 2'[monthyear])),[Processor_value],,DESC,Dense)

Another way:

add filter and measure in the visual level filter

rankall = RANKX(FILTER(ALLSELECTED('Table 2'),'Table 2'[monthyear]=MAX('Table 2'[monthyear])),CALCULATE(SUM('Table 2'[value])),,DESC,Dense)

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