Forum Discussion
Getting blanks (null) to NOT test as zero
So it seems every search on this topic I am coming up with questions on making null values (blank cells) show as zero, but what I am looking for is exactly the opposite. But first, let me clarify: th...
Anonymous , Move the blank first and try
Switch( True() ,
isblank('Planning & Performance'[Defect Opportunities] ) , "Blank" ,
'Planning & Performance'[Defect Opportunities] = 0, "Zero",
"OK")
https://docs.microsoft.com/en-us/dax/blank-function-dax
Blanks and empty strings ("") are not always equivalent, but some operations may treat them as such.
Looks like your data has empty strings, which are different than a BLANK.
hi the switch formula worked fine but for me, the trick was to add the ISBLANK case first than any others and then this worked. If I had the 0 case first, it didn't work as expected.