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

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.