RANKX - Filtering by more than one dimension

[yorkehead]

Hi,

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.

[v-chuncz-msft]

@yorkehead,

You may try using ALLSELECTED Function.

[yorkehead]

Hi @v-chuncz-msft

But how? Replacing just ALL for ALLSELECT doesn't work.

Thanks.