Does PowerBI not Distinguish between an empty field (BLANK) and the integer Zero (0)

[Anonymous]

Hi there folks

i have following problem, I want to exclude all empty fields from an IF-clause but keep fields with a zero. It seems like PowerBI does not distinguish between BLANK and the integer 0 in one of the columns because if I type in the following:

IF(ColumnX = BLANK() && ColumnY = BLANK(),do X, doY)

it also excludes rows in Column X and Column Y that include an integer 0 and the result than is X also it should be Y because for me 0 is not blank and i´m getting into trouble with this interpretation of powerbi^^

Where is the problem here? what can I do? 

In my case only Column Y includes 0

If I explicitly include the 0 in the IF (like: IF(ColumnX = BLANK() && ColumnY = BLANK() && ColumnY <>0,do X, doY)) to avoid this, PowerBi now thinks tha Blanks are 0 and now the result is Y even if both columns are blank. this confuses me...

[amitchandak · Accepted solution]

@Anonymous , Check with isblank once

IF(isblank([ColumnX])&& isblank(ColumnY),[do X],[doY])

[Anonymous]

hey amitchandakm,

thanks a lot, that helped perfectly 🙂