Forum Discussion

Daniil's avatar
Daniil
Kudo Kingpin
7 years ago
Solved

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

 

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)

Data Modeling

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    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