| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.custom |
|---|---|---|---|---|---|---|---|---|---|
XOR (MDX) |
XOR (MDX) |
kfollis |
kfollis |
kfollis |
02/17/2022 |
sql |
analysis-services |
reference |
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 |