DAX reading 0 as Blank and Vice Versa

[Anonymous]

I am using  an IfError statement in DAX

"IFERROR('PFEP'[Actual Inventory Level]-'PFEP'[Planned Inventory Level], BLANK())"

However, when Planned Inv. Level is blank, it is not being read as an error and therefore does not retrun blank but performs the subtraction as if Planned Inv. Level is 0 which I do not want it to do.

I tried fixing it by putting "IF(OR('PFEP'[Actual Inventroy Level]=BLANK(), 'PFEP'[Planned Inventory Level]=BLANK()), BLANK(), ...."

But in this case, 0 is read as blank for Actual and planned inventory level.

How can I solve thsi issue? 

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

Use this judgment condition alone, otherwise it does not work.

Column = IF('Table'[Value]=BLANK(),0,'Table'[Value])

Column = IF('Table'[Value]=0,BLANK(),'Table'[Value])

not work:

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

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