Forum Discussion
Daniil
Kudo Kingpin
Kudo KingpinIncorrect IF result
The following measure returns FALSE, although BLANK is expected: My Test = IF ( FALSE(), TRUE() ) At the same time, this measure returns BLANK as expected: My Test = IF ( FALSE(), "Yes" ) ...
Hi Daniil ,
When a column/measure defined as Boolean data type is involved in an expression, DAX only returns TRUE or FALSE from a logical expression.
For detailed description, please see: Handling BLANK in Boolean expressions
Best regards,
Yuliana Gu
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi Daniil ,
When a column/measure defined as Boolean data type is involved in an expression, DAX only returns TRUE or FALSE from a logical expression.
For detailed description, please see: Handling BLANK in Boolean expressions
Best regards,
Yuliana Gu