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 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 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
Anonymous please post a sample of your data and your expected result. Also be specific about where you are doing this. To AlB 's point, DAX for columns and measures is different becuase the former uses row context and the latter uses filter context, two totally different things. Formulas perfectly valid in one will fail in the other.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
