Forum Discussion
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.
HI AlB
I get information
"You cannot specify a single value for the 'Components.name' column in the 'merge1' table. This may be due to the fact that the measurement formula refers to a column containing many values without a specific aggregation, such as a minimum value, maximum value, number or sum, allowing to obtain a single result."
Hi Anonymous
Are you creating a calculated column or a measure?? That sounds like the message you would get when creating a measure. It should be fine with a calculated column
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