Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

ISBLANK() not working as expected?

Hi,   I'd like to add condition on my report only if the content of a column table in not empty/null/blank   I tried to do it with a measure, but I couldn't add it as a report filter, then I went...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    First, BLANK value and "" is not always the same

    Second, as you use measure, not a column it could return unexpected result because of row-context

    try a caclulated column like yours above or more sophisticated option

    = IF(ISBLANK('cerberus campaign'[Group1]) || 'cerberus campaign'[Group1] = "", true(), false())

     

az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

First, BLANK value and "" is not always the same

Second, as you use measure, not a column it could return unexpected result because of row-context

try a caclulated column like yours above or more sophisticated option

= IF(ISBLANK('cerberus campaign'[Group1]) || 'cerberus campaign'[Group1] = "", true(), false())

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi az38 !

     

    That worked for me!

     

    Thanks a lot