Include AND Exclude in Calculate Measure

Question

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"})

tamerj1 · Answer

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

adudani · Answer

hi&nbsp;StoryofData&nbsp;,TEST =CALCULATE(&nbsp; &nbsp;&nbsp;COUNTA('EDW Issues'[Subject ID]),&nbsp; &nbsp; &nbsp;ALL('EDW Issues'),&nbsp; &nbsp;&nbsp;'EDW Issues'[IemRoleInCase]&nbsp;IN&nbsp;{"Subject",&nbsp;"Reporter"},&nbsp; &nbsp;&nbsp;'EDW Issues'[Title Categorized]&nbsp;IN&nbsp;{"Staff",&nbsp;"Management"},&nbsp; &nbsp; 'EDW Issues'[Title Categorized]&nbsp;NOT IN&nbsp;{"XYZ",&nbsp;"ABC"})&nbsp;consider using&nbsp; || (or) , &amp;&amp; (and) if you want to join multiple conditions.&nbsp;