Scalar error in addcolumns

[MyWeeLola]

Good morning

I have unpivoted a table which gives me an ID column and an Attribute column. I have a lot of attributes to display, so I thought I would try to group them to make it easier for the user.

My thought was to create a calculated column that would apply my "grouped" titles to the attributes, however, I'm struggling to get the code I need.

In my example, I want the calculated column to apply, "Car, Plane, Ship"  to the relevant attribute

I was thinking

Vehicle = 

union(

addcolumns(

//goes wrong here

'mytable',"Type",'mytable'[attribute] = "Dodge","Car"),
//other selections

Dax is telling me that I have messed up with no scalar expression certified.

I think I'm trying to return the complete table, however I'm unsure how to this without "if then" statements

as a second question, in the example, if I specified which are ships and planes, could I make a default selection which makes the rest "cars"?

I look forward to hearing back.

Lola 

[v-jingzhan-msft · Accepted solution]

Hi @MyWeeLola 

The first method is to right click on the Attribute column and select New group. This feature can help you group values in this column through GUI easily and give you the group column you want. Use grouping and binning in Power BI Desktop - Power BI | Microsoft Learn

The second method is to use DAX to create a calculated column

Column = SWITCH(TRUE(),
'Table'[Attribute] IN {"Jet","Seaplane","Glider"}, "Plane",
'Table'[Attribute] IN {"Titanic"}, "Ship",
"Car"
)

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[MyWeeLola]

@v-jingzhan-msft 

Perfect, thank you for this.

Lola