Simply query DAX - IF null...

Hi Anonymous 

Perhaps

Column2 = IF (ISBLANK('merge1'[Components.name]); "1"; "0" )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

Hi Anonymous 

It seems you create a measure not a column, so it throw the error.

If you create a measure below, it can be right.

but if the [Components.name] column is of text type, null value doesn't mean to be blank, it is a "null" text value.

you can create a measure like

Measure = if(MAX('Table'[Components.name])<>"null", "1","0")

But measures can't be added into slicer, it just can be added into visual level filter.

To create a column and add it into a slicer,

Column = if('Table'[Components.name]<>"null", "1","0")

or 
Column = if(ISBLANK('Table'[Components.name]), "0","1")

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.