Forum Discussion

Sssginc1's avatar
Sssginc1
Frequent Visitor
4 years ago
Solved

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 co...
  • AlexisOlson's avatar
    4 years ago

    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's avatar
    4 years ago

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