Turn IF Expression to Calculated Dimension

[#1]

Hi,

I'm trying to turn the following expression in a straight table to a calculated dimension. I can't get the syntax right. Can anyone help?

=If(Count(DISTINCT{<[Store Status]= {'Not On Store'}>} Territory) > 0, [Territory Name],Null())

Thanks!

[ramoncova06]

whenever you use an aggregation as part of a calculated dimension you need to use aggr

aggr(only({<[Territory Name] = {"Count(DISTINCT{<[Store Status]= {'Not On Store'}>} Territory) > 0"}>} [Territory Name]),[Territory Name])

[#3]

Try Like below:

IF( Aggr( Count(DISTINCT{<[Store Status]= {'Not On Store'}>} Territory) , [Territory Name]) > 0 , [Territory Name] )