Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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...
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.
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.
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.
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.
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.
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...
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.
It works well thank you very much for your help
🙂 No problem. Happy to help!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |