The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi! According to https://learn.microsoft.com/en-us/dax/summarizecolumns-function-dax#contextual-summarizecolumns
From June 2024, we are enabling contextual SummarizeColumns which allows SummarizeColumns to be evaluated in any context transition, SummarizeColumns in measure is now fully supported.
I am using the SUMMARIZECOLUMNS function in a measure which works perfectly fine in Power BI Desktop BUT produces the error message in the service:
Is it possible that my workspace did not get the Jun 2024 update yet? Or are there still contexts in which SUMMARIZECOLUMNS cannot be used?
Thanks in advance.
Solved! Go to Solution.
@ManuGP Use alternative DAX functions of SummarizeColumns such as SUMMARIZE, ADDCOLUMNS, or GROUPBY, check these and let me know if there are any issues.
Verify that your Power BI workspace has been updated to the June 2024 version or later by checking with the admin portal or whoever is in charge.
Thanks @ahadkarimi. I am still waiting to get technical help from my admins (ideally to know if the workspace is in June 2024). I'm really more interested in understanding the new capabilities of SUMMARIZECOLUMNS and when it should / shouldn't work (is it expected that some scenarios work in desktop but not in the service or is it indicative that there is something wrong in the service?). I have some time so I can wait for answers before going with alternative DAX functions.
@ManuGP Use alternative DAX functions of SummarizeColumns such as SUMMARIZE, ADDCOLUMNS, or GROUPBY, check these and let me know if there are any issues.
Verify that your Power BI workspace has been updated to the June 2024 version or later by checking with the admin portal or whoever is in charge.