cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Summarize function failed

Hello,
I would like to display some number per trader so I used the following formula :

 'Colonne = SUMMARIZE(ifp_vte1;ifp_vte1[Nom Commercial];"SommeParCommercial";SUM(ifp_vte1[Mt HT]))'

But  But it does not work,
It displays the error:
The expression refers to multiple columns. Multiple columns can not be converted to a scalar value.


What can I do to solve this problem ?

thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Summarize function failed

Are you adding this new calculation as column or measure? Here is solution in the forum https://community.powerbi.com/t5/Desktop/Create-a-new-table-in-power-BI-with-SUMMARIZE-function/td-p...






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.





View solution in original post

7 REPLIES 7
Highlighted
Frequent Visitor

Re: Summarize function failed

Hi,

 

I'm relatively new to Power BI but have used the SUMMARIZE function a few times. What happens if you replace the ; with a comma (,) ? Is it maybe just a syntax issue with DAX?

 

Thanks,

 

Tom.

Highlighted
Helper I
Helper I

Re: Summarize function failed

Hi Tom
thank you for your reply
I replaced ; By, but it returns the same error
The expression refers to multiple columns. Multiple columns can not be converted to a scalar value.

Highlighted
Super User IV
Super User IV

Re: Summarize function failed

here is the link for summarize function https://msdn.microsoft.com/en-us/library/gg492171.aspx?f=255&MSPPError=-2147217396 and seems like the issue is with the syntax.






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.





Highlighted
Super User IV
Super User IV

Re: Summarize function failed

Are you adding this new calculation as column or measure? Here is solution in the forum https://community.powerbi.com/t5/Desktop/Create-a-new-table-in-power-BI-with-SUMMARIZE-function/td-p...






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.





View solution in original post

Highlighted
Frequent Visitor

Re: Summarize function failed

Backing up what parry2k suggested, SUMMARIZE will return a table and not a single value. I've just tried:

 

- Opening the data tab on the left hand menu of Power BI Desktop.

-Clicking the New Table option.

-In the DAX formula bar at the top, I typed

 

MyNewTable = SUMMARIZE('MyWebData','MyWebData'[Page Title],"AVERAGETIME",SUM('MyWebData'[msr_AverageTimeOnPage]))

 

This created a new table with my aggregated data. I could then see that new table in my data sets on the right hand side. Hope that helps you try something similar.

 

Tom.

Highlighted
Helper I
Helper I

Re: Summarize function failed

It works well thank you very much for your help

 

Highlighted
Frequent Visitor

Re: Summarize function failed

🙂 No problem. Happy to help!

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors