NOT DAX Function

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-

• Global Super Store Dataset

Let’s understand with an example:

Add Region & Sales column data into Table visual-

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-

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.