Incorrect IF result

[Daniil]

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" )

I can't see how this is a feature, not a bug.

I am using Power BI Desktop 2.67.5404.801 64-bit (March 2019)

[v-yulgu-msft · Accepted solution]

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