| title | XOR (MDX) |
|---|---|
| description | XOR (MDX) |
| ms.date | 02/17/2022 |
| ms.service | sql |
| ms.subservice | analysis-services |
| ms.topic | reference |
| ms.custom | mdx |
Performs a logical exclusion on two numeric expressions.
Expression1 XOR Expression2
Expression1
A valid Multidimensional Expressions (MDX) expression that returns a numeric value.
Expression2
A valid MDX expression that returns a numeric value.
A Boolean value that returns true if one and only one argument evaluates to true; otherwise, false.
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 |