topic Re: The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value. in DAX Commands and Tips

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

Anonymous — Mon, 29 Jul 2024 14:58:24 GMT

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.

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

Greg_Deckler — Mon, 29 Jul 2024 15:25:31 GMT

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.

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

Anonymous — Mon, 29 Jul 2024 16:29:11 GMT

thanks you Greg_Deckler for clarification.

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

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

Anonymous — Tue, 30 Jul 2024 07:21:33 GMT

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.