Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

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

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.
1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

vkaiyuemsft_0-1722324080823.png

 

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.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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.

vkaiyuemsft_0-1722324080823.png

 

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
Not applicable

thanks you @Greg_Deckler  for clarification. 

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

 

Greg_Deckler
Community Champion
Community Champion

@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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.