Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

calculated column doesn't show blanks

I have a column in the dataset (Query), which has 3 values: 1, 0 and null. When creating visualizations, I figured I need a different representation of that column. So, I created a Calculated Column...
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous,

    I have asked the Product Group and they replied that: "In DAX, the comparison operator = performs equivalence comparison. Since 0 and BLANK are equivalent values, operator = returns true when comparing 0 to BLANK. Users can use DAX function IsBlank to detect BLANK values. "

    Hope it could help you.

     

    Regards,

    Daniel He

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

I have asked the Product Group and they replied that: "In DAX, the comparison operator = performs equivalence comparison. Since 0 and BLANK are equivalent values, operator = returns true when comparing 0 to BLANK. Users can use DAX function IsBlank to detect BLANK values. "

Hope it could help you.

 

Regards,

Daniel He

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks Daniel. This is really helpful. It's just that "Column from Examples" in Edit Queries, works differently. :)