Not equal to (<>) DAX Operator
The “not equal to” operator <> returns TRUE when the two arguments do not have the same value.
A comparison between BLANK and 0 or between BLANK and an empty string returns FALSE.
Use the == operator to treat BLANK and 0 or empty string as different values.
This operator does not perform any implicit conversion between strings, numbers, and Boolean values.
The following are valid expressions using the “not equal to” operator.
Product[Color] <> "Red" Sales[Quantity] <> 0 Customer[LargeFamily] <> TRUE
See Handling BLANK in DAX for more details about BLANK comparisons.
Last update: Aug 9, 2022 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Ed Hansberry, Kenneth Barber,
2018-2022 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies