How to differentiate between 0 and blank in DAX queries? Whatever query I write, it always considers 0 the same as blank().
My data has blank and 0 as two different values instead of being the same thing.
Go to Solution.
Try using ISBLANK() instead of comparing to BLANK().
For some reason, those are treated differently. Check out this screenshot:
The two DAX formulas:
BlankCheck = ISBLANK(Numbers[Number])
BlankCheckIf = IF(Numbers[Number] = BLANK(), TRUE(), FALSE())
Here's a good article for some additional information, including truth tables with BLANK() comparisons:
View solution in original post
using this DAX statement to create a calculated column
IF(ISBLANK('ColumnWithMissingValues'[ColumnWithMissingValues]), "TRUE", "FALSE")
leads to this result
Hopefully this is what you are looking for
Click here to learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 25 of Ted's Dev Camp.