Currently I have this two metrics for having a top 10:
Rank:=RANKX(ALL('Table A'[column table A]),[metric])
Top 10 := IF(Rank] <= 10,[metric],IF(HASONEVALUE(Table A'[column table A]),IF(VALUES('Table A'[column table A]) = "Others",SUMX(FILTER(ALL(Table A'[column table A]),[Rank] > 10),[metric]))))
And it works well. But if I filter by another dimension I always get the same rank and consequently not having the top 10.
How can I make this work with another dimensions?
Thanks in advance.
You may try using ALLSELECTED Function.
But how? Replacing just ALL for ALLSELECT doesn't work.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!