topic Re: value = BLANK() versus ISBLANK(value) in DAX Commands and Tips

value = BLANK() versus ISBLANK(value)

lbendlin — Thu, 11 Jun 2020 12:21:04 GMT

This is a followup from https://community.powerbi.com/t5/DAX-Commands-and-Tips/seaching-for-keywords-in-text-for-use-as-index-seach-function/m-p/1152135

Why does this work?

but this doesnt?

Re: value = BLANK() versus ISBLANK(value)

lbendlin — Thu, 11 Jun 2020 12:49:45 GMT

Mystery solved. CONCATENATEX never returns blank. At the minimum it returns an empty string. So there seems to be a bug in DAX that allows the comparison of an empty string to BLANK() to be true.

Re: value = BLANK() versus ISBLANK(value)

lbendlin — Thu, 11 Jun 2020 13:08:49 GMT

marcorusso I ran this in DAX studio. Is there a good explanation for this?

evaluate row(
"Test1",ISBLANK(""),
"Test2",""=BLANK()
)

Re: value = BLANK() versus ISBLANK(value)

Anonymous — Thu, 11 Jun 2020 14:14:03 GMT

Hi lbendlin ,

https://www.youtube.com/watch?v=C26DQkb4hyY

Have a look at this video.

Regards,

Harsh Nathani

Re: value = BLANK() versus ISBLANK(value)

lbendlin — Thu, 11 Jun 2020 14:34:22 GMT

Anonymous Thank you. I am not ashamed to admit that I was not aware of the equality operator ("==") being available in DAX. That makes more sense now. Single equal sign does a type transformation. Thanks again!

Re: value = BLANK() versus ISBLANK(value)

marcorusso — Thu, 11 Jun 2020 17:51:23 GMT

Here: https://www.sqlbi.com/articles/blank-handling-in-dax/

Re: value = BLANK() versus ISBLANK(value)

lbendlin — Thu, 11 Jun 2020 18:37:47 GMT

Thank you Marco. Would be nice if the article could also mention the "==" operator.

Re: value = BLANK() versus ISBLANK(value)

marcorusso — Fri, 12 Jun 2020 17:59:07 GMT

Good suggestion, I just added an example of == in that article. Thanks!