NOT
The opposite of a logical value.
Group: Logical. Compatible with DAX.
Syntax
NOT ( <logical> )| Parameter | Type | Description |
|---|---|---|
logical | Boolean | The condition to turn round. |
Returns
Boolean. TRUE for FALSE, FALSE for TRUE.
Remarks
- It can be written as an operator too:
NOT ISBLANK ( x )needs no brackets around its argument. - A blank counts as FALSE, so
NOT ( BLANK () )is TRUE. A number counts as TRUE unless it is 0. Text is an error.
Examples
NOT of a few values
EVALUATE
ROW (
"TRUE", NOT ( TRUE () ),
"Blank", NOT ( BLANK () ),
"0", NOT ( 0 ),
"5", NOT ( 5 )
)| TRUE | Blank | 0 | 5 |
|---|---|---|---|
| FALSE | TRUE | TRUE | FALSE |
Bonds with a price
EVALUATE
ROW ( "Priced", COUNTROWS ( FILTER ( Holdings, NOT ISBLANK ( Holdings[Price] ) ) ) )| Priced |
|---|
| 3 |