NOT Function (DAX)

How does the NOT function (DAX) work?

The NOT function (DAX) returns the opposite of a given logical or boolean value. When given TRUE, NOT returns FALSE.When given FALSE, NOT returns TRUE. 

NOT Formula Syntax

NOT(
     <logical>
)

How do you use the NOT function?

Use the NOT function to reverse a logical value.

Related Blog Posts

Related Support Forum Posts

Dax Calculation question
Dax not working
DAX Buffer Calculation Query

Considerations when using the NOT function

If the logical_value is TRUE, then the NOT function will return FALSE.
If the logical_value is FALSE, then the NOT function will return TRUE.

Related Video Tutorials

Formula examples using the NOT function

=NOT([CalculatedColumn1])

=NOT(TRUE)

=NOT(A2=”Microsoft”)

Related DAX Functions

TRUE
FALSE
IF

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership