Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 :
Solved! Go to 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())
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())
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |