Filter condition in calculated dimension

[#1]

I have a dimension 'Country Name'. I want to find 'Top 10' countries based on Revenue. So, in calculated dimension, I used:

if(aggr(rank(sum(Revenue)),[Country Name])<=10,[Country Name])

Problem statement:

My new requirement is, I don't want to consider some countries while I find top 10 countries. Let us say, I want to exclude COUNTRY_1 in calculated dimension.

I used :

if(aggr(rank(sum(Population)),

if(([Country Name])<>'COUNTRY_1',[Country Name])

)<=10,[Country Name])

But this is not working. Can you please help?

[PrashantSangle]

hi,

try like

if(not wildmatch([Country Name],'Country_1') and aggr(rank(sum(Revenue)),[Country Name])<=10,[Country Name])

Regards

[PrashantSangle · Accepted solution]

or you can try below expression also

if(aggr(rank(sum({<[Country Name]-={"Country_1"}>}Revenue)),[Country Name])<=10,[Country Name])

Regards,

[#4]

That was right under my nose...and I missed it.

Thank you!