Forum Discussion
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 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 :
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())
2 Replies
- az38
Community Champion
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())