Home » DAX » NOT DAX Function

NOT DAX Function

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




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

Region Sales Data

Now create a measure for NOT Function, see the below DAX code-

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

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.

Leave a Reply