XOR (MDX)
Performs a logical exclusion on two numeric expressions.
Syntax
Expression1 XOR Expression2
Parameters
Expression1
A valid Multidimensional Expressions (MDX) expression that returns a numeric value.
Expression2
A valid MDX expression that returns a numeric value.
Return Value
A Boolean value that returns true if one and only one argument evaluates to true; otherwise, false.
Remarks
The XOR operator treats both parameters as Boolean values (zero, 0, as false; otherwise, true) before the operator performs the logical exclusion. The following table illustrates how the XOR operator performs the logical exclusion.
| Expression1 | Expression2 | Return Value |
|---|---|---|
| true | true | false |
| true | false | true |
| false | true | true |
| false | false | false |