Forum Discussion

MyWeeLola's avatar
MyWeeLola
Icon for Helper II rankHelper II
2 years ago
Solved

Scalar error in addcolumns

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 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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!

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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!