Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Move the blank first and try

     

    Switch( True() ,
    isblank('Planning & Performance'[Defect Opportunities] ) , "Blank" ,
    'Planning & Performance'[Defect Opportunities] = 0, "Zero",
    "OK")

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi Anonymous ，

In your sample, if you modify it like this:

 

You can see it also return the wrong result, because DAX treats BLANK() and 0 (zero) as the same value, You can use the ISBLANK function to distinguish blank and 0.

 

Here’s some information may help you to understand.

https://www.burningsuit.co.uk/how-dax-treats-nulls-zeros/

https://docs.microsoft.com/en-us/dax/isblank-function-dax

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.