THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Performs a logical negation on a numeric expression.


NOT Expression1  


A valid Multidimensional Expressions (MDX) expression that returns a numeric value.

Return Value

A Boolean value that returns false if the argument evaluates to true; otherwise, true.


The NOT operator treats the expression as a Boolean value (zero, 0, as false; otherwise, true) before the operator performs the logical negation. The following table illustrates how the NOT operator performs the logical negation.

Expression1 Return Value
true false
false true

See Also

MDX Operator Reference (MDX)