Auto Slice Category by Name

[sugriwo]

Please help,

I have a graph like this,
there are names and categories along with their ranking.

for example, if I choose the name "RAHA" and in my data enter the POS category. and I want to create a ranking table based on its category without taking action to click on the Category filter.

So it's like automation without choosing a filter category, if I choose one name and see the ranking of the name based on the name category. 

Thanks,

[v-lili6-msft]

Hi@sugriwo

You can try to use  ALLEXCEPT Function to create a measure like below:

Rank = RANKX ( ALLEXCEPT(Table3,Table3[Gategory]),CALCULATE ( SUM ( Table3[Productivity]) ), ,DESC,DENSE)

Result:

Best Regards,

Lin