The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

[Sssginc1]

This is driving me nuts. Simple model for illustrative purposes:

Here is my GROUPBY():

Have tried this countless ways and watched endless YouTube video but cannot figure out why I am consistently getting this same error. Tried the SUMMARIZE() function and got the same error there too.

Grateful for any guidance. Thanks.

Larry

[AlexisOlson · Accepted solution]

Are you trying to define a measure or a calculated column or a calculated table?

Your DAX returns a table with two columns (Region and SalesResults) and will give this error if you are trying to define something that isn't a table.

[Sssginc1 · Accepted solution]

Trying to define a measure. That's the problem. Just re-tried as a "New Table" and it worked. Thanks very much!

[AlexisOlson · Accepted solution]

Are you trying to define a measure or a calculated column or a calculated table?

Your DAX returns a table with two columns (Region and SalesResults) and will give this error if you are trying to define something that isn't a table.