Forum Discussion
StoryofData
Helper III
Helper IIIInclude 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...
adudani
Memorable Member
Memorable Memberhi 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.
StoryofDataHelper III
Helper IIIThis did work after cleaning up few things in the data: 'EDW Issues'[IssueSub Formatted] <> "Ask a Question"