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 ?
Solved! Go to Solution.
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?
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.
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.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Learn about the exciting things that happened in July.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.