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

[Anonymous]

i am trzing to use this in DAX to create new measure. 

Measure3 =

SUMMARIZE(

    GesamtsichtV2X;

    GesamtsichtV2X[Activity];

    "B"; SUM(GesamtsichtV2X[B])

)

how wver i get this error: The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

Activity is a column with a code 6,7,8,9 and column B has the dollar amount. 

i have no idea what that error means. 

would appreciate any help.

[Anonymous · Accepted solution]

Hi @Anonymous ,

I’d like to acknowledge the valuable input provided by the @Greg_Deckler . Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue. 

If you don't need a dynamic context, you can put it in a calculated table to display it.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

thanks you @Greg_Deckler  for clarification. 

my only option would be to transform via power query, am i right?

[Greg_Deckler]

@Anonymous SUMMARIZE returns a table of values but measures, unfortunately, can only return scalars (single values). That is what the error means. So you need to do something like wrap your SUMMARIZE in a MAXX or SUMX or something like that so that it returns a single value and not a table of values.