topic Re: Include AND Exclude in Calculate Measure in DAX Commands and Tips

Include AND Exclude in Calculate Measure

StoryofData — Sat, 25 Feb 2023 17:27:34 GMT

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", "Reporter"},

'EDW Issues'[Title Categorized] IN {"Staff", "Management"})

Re: Include AND Exclude in Calculate Measure

adudani — Sat, 25 Feb 2023 17:40:34 GMT

hi StoryofData ,
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"}
)

consider using || (or) , && (and) if you want to join multiple conditions.

Re: Include AND Exclude in Calculate Measure

StoryofData — Sat, 25 Feb 2023 17:56:47 GMT

That gives me an error, unexpected expression...

Re: Include AND Exclude in Calculate Measure

StoryofData — Sat, 25 Feb 2023 23:17:08 GMT

This did work after cleaning up few things in the data: 'EDW Issues'[IssueSub Formatted] <> "Ask a Question"

Re: Include AND Exclude in Calculate Measure

tamerj1 — Sat, 25 Feb 2023 18:48:42 GMT

adudani

NOT ( 'EDW Issues'[Title Categorized] IN {"XYZ", "ABC"} )