topic Re: "SummarizeColumns() and AddMissingItems() may not be used in this context" in June 2024 in DAX Commands and Tips

"SummarizeColumns() and AddMissingItems() may not be used in this context" in June 2024

ManuGP — Tue, 13 Aug 2024 16:02:36 GMT

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.

Re: "SummarizeColumns() and AddMissingItems() may not be used in this context" in June 2024

ahadkarimi — Tue, 13 Aug 2024 20:42:01 GMT

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.

Re: "SummarizeColumns() and AddMissingItems() may not be used in this context" in June 2024

ManuGP — Wed, 21 Aug 2024 07:11:10 GMT

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.