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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RGL
Helper II
Helper II

Where is the error )

I have this and I don't see a difference from the example in Microsoft docs
 
SUMMARIZE(Venta,
Calendario[SemanaCom],
Clientes[C CLIENTE],
Clientes[N CLIENTE],
"Venta",sum(Venta[Importe]))
 
I get this error:
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
 
What should I change?
 
1 ACCEPTED SOLUTION
camargos88
Community Champion
Community Champion

@RGL ,

 

Unless you are creating a table, you are gonna get this error. 

Measures and calculated columns are scalar values. So, if it's the case your return has to be a single value.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

6 REPLIES 6
camargos88
Community Champion
Community Champion

@RGL ,

 

Unless you are creating a table, you are gonna get this error. 

Measures and calculated columns are scalar values. So, if it's the case your return has to be a single value.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



@camargos88 

It has to be a table!!!

 

Thanks!

Tahreem24
Super User
Super User

Is this measure or calculated column or calculated table?

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
parry2k
Super User
Super User

@RGL did you set up the relationship between these tables? How does that looks like?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

@parry2k  Yes, they are related by the [C Cliente] key and the [Date] key... I have other measures involving these that work...

@RGL cannot say anything without looking at it, share sample pbix file.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.