ISBLANK() and IF(...=BLANK()) return different results

[Cynwaa]

Hi Power BI Community, I ran into a strange mistake here:

I accidentally discoved that when I use

IF([Column]=BLANK(), "TRUE", "FALSE")

the returned value is different from

ISBLANK([Column])

Dose anyone have any idea why would it be the case? 

Codes:

lOOKUPVALUE = LOOKUPVALUE(Consolidated[VALUE],Consolidated[KEY],'Results'[KEY])

IF blank = IF(LOOKUPVALUE(Consolidated[VALUE],Consolidated[KEY],'Results'[KEY])=BLANK(),"TRUE","FALSE")

ISBLANK = ISBLANK(LOOKUPVALUE(Consolidated[VALUE],Consolidated[KEY],'Results'[KEY]))

[v-yuta-msft]

@Cynwaa ,

Could you share the sample data of report table?

Community Support Team _ Jimmy Tao

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

[Cynwaa]

@v-yuta-msft , thanks for your reply! 

below are links for the sample data. 

Power BI file: https://www.dropbox.com/s/uj9my9xiewiswdh/Test.pbix?dl=0

Source data in excel: https://www.dropbox.com/s/hgm837seq3ll7wo/Test.xlsx?dl=0

[v-yuta-msft]

@Cynwaa ,

Sorry for late, there's some difference between these two functions, if you change one "0" to "NULL" or nothing, ISBLANK() can work. But if the value is "0", ISBLANK will recognize it as a number "0".

  

Community Support Team _ Jimmy Tao

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

[Cynwaa]

@v-yuta-msft thanks a lot for your reply. 

I think the ISBLANK() function is always working alright, but my question is rather: why doesn' t the IF function work?

IF([Column]=BLANK(), "TRUE", "FALSE")

[v-yuta-msft · Accepted solution]

@Cynwaa ,

No, IF() function works well, because "0 = BLANK()" will always return bool value "TRUE".

Community Support Team _ Jimmy Tao

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

[Cynwaa]

ah ok ... thanks a lot for this answer, I think that's the problem.

But why 0=BLANK() is true? That is not so intuitively understandable.. 

[Oscar_Mtz_V]

Hey @Cynwaa , here is the explanation