Forum Discussion
lbendlin
Super User
Super Uservalue = BLANK() versus ISBLANK(value)
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?
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.
7 Replies
- lbendlin
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.
- lbendlin
marcorusso I ran this in DAX studio. Is there a good explanation for this?
evaluate row(
"Test1",ISBLANK(""),
"Test2",""=BLANK()
)- marcorusso
Most Valuable Professional
