ISBLANK() not working as expected?

[Anonymous]

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 with adding a new column in my table (in Data Editor) to check if the column is blank, using the ISBLANK() function

As you can see here, the ISBLANK() function return false even if there is no value (empty string)

My isGroup1Blank column is defined with : 

isGroup1Blank = ISBLANK('cerberus campaign'[Group1])

[az38 · Accepted solution]

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]

Hi @az38 !

That worked for me!

Thanks a lot