Filtering a dimension based on a condition.

[Anonymous]

I want to to create a Master Item to be used as a Dimension in some of my charts. I need to show only the streets with more than 9 houses.

I tried the following:

=if([STREET]=(Sum(NUM_OF_HOUSES)>=10),[STREET],Null())

But it returns an Invalid Dimension, any ideas?

Thanks in advance.

[OmarBenSalem · Accepted solution]

if(  aggr(sum( NUM_OF_HOUSES),STREET)>=10, STREET, Null())