It’s a logical DAX function that used to change a value or expression from FALSE to TRUE or TRUE to False.
Refer other logical functions- OR, AND
Syntax:
NOT(<logical>)
Parameters
logical – A value or expression that can be evaluated to TRUE or FALSE.
Download the sample Dataset from below link-
Let’s understand with an example:
Add Region & Sales column data into Table visual-

Region Sales Data
Now create a measure for NOT Function, see the below DAX code-
NOT_DAX = CALCULATE( SUM('Global-Superstore'[Sales]), FILTER('Global-Superstore', NOT('Global-Superstore'[Region]) IN {"Africa", "Canada", "Caribbean"} ))
Above DAX function will returns total sales of region excluding these three regions – “Africa”, “Canada”, “Caribbean”.
You can see the below result of NOT DAX function-

NOT DAX Result
Refer more DAX functions: DAX functions
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our Contact form , we will revert to you asap.