Forum Discussion
Include AND Exclude in Calculate Measure
How do I add on to this to EXCLUDE values from columns? TEST = CALCULATE( COUNTA('EDW Issues'[Subject ID]), ALL('EDW Issues'), 'EDW Issues'[IemRoleInCase] IN {"Subject", "Report...
hi StoryofData ,
TEST =
TEST =
CALCULATE(
COUNTA('EDW Issues'[Subject ID]),
ALL('EDW Issues'),
'EDW Issues'[IemRoleInCase] IN {"Subject", "Reporter"},
'EDW Issues'[Title Categorized] IN {"Staff", "Management"},
'EDW Issues'[Title Categorized] NOT IN {"XYZ", "ABC"}
)
'EDW Issues'[Title Categorized] NOT IN {"XYZ", "ABC"}
)
consider using || (or) , && (and) if you want to join multiple conditions.
That gives me an error, unexpected expression...