How to exclude certain dimension values

[#1]

Dimension: StoreName

Expression: sum(Revenue)

I am trying to exclude the dimension to include only stores that have >100 customer accounts associated with it. How do I go about doing this?

I tried

if(count(DISTINCT Account)>100, StoreName)

but that doesn't seem to work. Should I be using an aggr() function? Set analysis?

Thank you!

[maxgro]

sum({$<StoreName={"=count(distinct Account)>100"}>} Revenue)

[#3]

Thanks, Massimo!

I would use that as the expression, but is there any way I could exclude those dimension values using a calculated dimension rather than doing it in the expression?

[maxgro · Accepted solution]

=if(aggr(count(DISTINCT Account), StoreName)>100, StoreName)

[#5]

That worked perfectly. Thank you!