Skip to main content
Version: I2023.2.0

Logical Operators (MDX)

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

OperatorDescription
ANDPerforms a logical conjunction of two numeric expressions. Returns true if both parameters evaluate to true; otherwise, returns false.
ORPerforms a logical disjunction on two numeric expressions. Returns true if either or both arguments evaluate to true; otherwise, false.
XORPerforms a logical exclusion on two numeric expressions. Returns true if one and only one argument evaluates to true; otherwise, false.
NOTPerforms a logical negation on a numeric expression. Returns false if the argument evaluates to true; otherwise, true.