Logical Operators (MDX)

Logical operators are used to combine arguments in a Boolean expression (an expression that evaluates to true or false).

Operator	Description
AND	Performs a logical conjunction of two numeric expressions. Returns true if both parameters evaluate to true; otherwise, returns false.
OR	Performs a logical disjunction on two numeric expressions. Returns true if either or both arguments evaluate to true; otherwise, false.
XOR	Performs a logical exclusion on two numeric expressions. Returns true if one and only one argument evaluates to true; otherwise, false.
NOT	Performs a logical negation on a numeric expression. Returns false if the argument evaluates to true; otherwise, true.