Forum Discussion
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
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
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.
Trying to define a measure. That's the problem. Just re-tried as a "New Table" and it worked. Thanks very much!
2 Replies
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.
Trying to define a measure. That's the problem. Just re-tried as a "New Table" and it worked. Thanks very much!