How to negate IS operator

mdx

#1

Hello, I have condition like:
CASE WHEN [Client].CurrentMember IS [Client].DefaultMember THEN ...
and I would like to know how can I make opposite condition - I want to trigger when I am NOT in default member. I have tried NOT statement, but it does not work. Another possibility to try it over ELSE statement. Then it works, but i have to fill something into the ELSE part.

Is there any way how I could negate such condition?


#2

I can add some nonsense condition into ELSE statement

CASE WHEN [Client].CurrentMember IS [Client].DefaultMember THEN
  Case WHEN [Client].CurrentMember IS [Issue].DefaultMember THEN 999 END
ELSE
 "In this case i am not IN default Client."
END

It works, but it is disgusting workaround (its my workaround so I can criticize it :grinning:)

Is there any better way?