Summarize function failed

[Betissa]

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.

[tommcmaster]

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.

[tommcmaster]

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.

[parry2k]

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.

[parry2k · Accepted solution]

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

[Betissa]

It works well thank you very much for your help

[tommcmaster]

🙂 No problem. Happy to help!

[Betissa]

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.