How to add NOT in my expression ?

[admin11]

Hi All

Below expression working fine :-

_WONnLOSTonly_alq = IF ( 'CRM_TS'[Stage]= Blank(), "No Deal",if (CRM_TS[Stage] in {"7 Order Won","8 Order Lost"},"1","0"))

Above expression will return only :-

7 Order Won

8 Order Lost

I like to modify the expression , So that it will return not :-

7 Order Won

8 Order Lost

I have try :-

_WONnLOSTonly_alq = IF ( 'CRM_TS'[Stage]= Blank(), "No Deal",if (CRM_TS[Stage] NOT in {"7 Order Won","8 Order Lost"},"1","0"))

Also try :-

_WONnLOSTonly_alq = IF ( 'CRM_TS'[Stage]= Blank(), "No Deal",if NOT (CRM_TS[Stage] in {"7 Order Won","8 Order Lost"},"1","0"))

All above both not working 

Paul

[KayceVC · Accepted solution]

It sounds like you want your formula to calculate when CRM_TS[Stage] is blank or when it is not 7 or 8. For that, all you should need is:

IF ( 'CRM_TS'[Stage]= Blank(), "No Deal",
IF('CRM_TS'[Stage] <> "7 Order Won"  && 'CRM_TS'[Stage] <> "8 Order Lost","1","0"))

This is basically telling the 2nd IF that if 'CRM_TS'[Stage] is not equal to 7 AND 'CRM_TS'[Stage] not equal to 8, then 1 else 0. 

[admin11]

@KayceVC 

Thank you very much , it work.