Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Error message The expression refers to multiple columns. Multiple columns cannot be converted to a s

Hi,   I got error an message when i would like to group by customer key and summing the revenue.  The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value....
Need Help
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

are you sure you create a table and not a measure?

I also see you have no closing parenthesys ")" for statement

and also I see an excess space here

[Customer ke y]

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi, 

     

    I want to create the new measure to sum the net turnover by customer key group. 

     

     

     

    Demo = 
SUMMARIZE(
    ALLSELECTED(ESD),
    ESD[Customer key],
    "Revenue",SUM(ESD[Net turnover (EUR)])
)

     

    • AlB's avatar
      AlB
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Hi Anonymous 

      Your measure is returning a table now. That is not allowed and from what I understand it is not what you need either. You probably need a SUMX on what you currently have or something along those lines.

      That use of summarize is not recommended. Better to use SUMMARIZE only for generating the base table, not for adding columns. You can use ADDCOLUMNS for that or SUMMARIZECOLUMNS

      https://dax.guide/summarize/

      https://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/

      https://dax.guide/summarizecolumns/

      Please mark the question solved when done and consider giving kudos if posts are helpful.

      Contact me privately for support with any larger-scale BI needs, tutoring, etc.

      Cheers 

Related content