Calculated dimension in an expression

[tinkerz1]

I am trying to understand how a calculated dimension fits into an expression.

If I label the calculated dimension, why cant I use this in the set analysis part of the expression?

And what is the work around?

My calculated dimension

Label 'ABC Status'

=IF(len([Action])=1,IF(([Created Date]+[Days])>[Load Date],'On Track','Overdue'),'Placed')

My Set expression

=count(DISTINCT {$<[ABC Status]={'Overdue'}> + <[ABC]={'On Track'}>} [Action])

[Gysbert_Wassenaar]

Only fields can be used in set modifiers on the left side of the =. Expressions, expression labels and labels of calculated dimensions cannot be used.

[MarcoWedel]

As [ABC Status] = 'On Track' or [ABC Status] = 'Overdue'  should define the same set as Len(Action)=1 one solution might be:

=Count(DISTINCT {$<Action={"=Len(Action)=1"}>} Action)

hope this helps

regards

Marco