NOT DAX Operator
NOT inverts the state of a boolean expression, transforming FALSE to TRUE, or TRUE to FALSE.
NOT is an operator and not a function. Because of the precedence rules, the expression that follows NOT might be evaluated in an unexpected way if you think that NOT is a function.
EVALUATE
{
-- NOT evaluates the result of the multiplication
( "NOT ( FALSE ) * FALSE", "" & NOT ( FALSE ) * FALSE ),
-- NOT evaluates the result of the multiplication
( "NOT ( FALSE * FALSE )", "" & NOT ( FALSE * FALSE ) ),
-- NOT evaluates only the first FALSE function
( "( NOT FALSE ) * FALSE", "" & ( NOT FALSE ) * FALSE )
}
| Value1 | Value2 |
|---|---|
| NOT ( FALSE ) * FALSE | TRUE |
| NOT ( FALSE * FALSE ) | TRUE |
| ( NOT FALSE ) * FALSE | 0 |
Last update: Jun 16, 2022 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber, Martin de la Herran
2018-2022 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies