sugriwoFrequent Visitor8 years agoAuto Slice Category by Name 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 cre...Show More
v-lili6-msftCommunity Support8 years agoHi@sugriwoYou 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
