Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Difference between blank and empty in advanced filtering

Hi everyone, I'm seeing a new dropdown option in the advanced filtering of dimensions. What's the difference between "blank" and "empty"?    
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    Kudo for your eagle eyes - this is a new setting in the service.  BLANK is the equivalent of null, while "empty"  is the equivalent of "" (an empty string). 

lbendlin's avatar
lbendlin
Super User
3 years ago

ISBLANK() refers to scalar values (individual cells).  ISEMPTY() refers to tables.  In DAX "everything is a table" - some just happen to be single column single row tables.

joglidden2's avatar
joglidden2
Post Patron
3 years ago

Really.?. That's not a good paradigm, IMO. Why would they limit the product like that? As if scalar values have no utility. As in, y'know, linear algebra n'stuff. How interesting, and good to keep in mind. Interesting.