https://community.fabric.microsoft.com/t5/Report-Server/Issue-with-DAX-function-SummarizeColumns-Power-BI-Report-Server/m-p/4269647#M38474 <P>you would need to show more details about your measure. Does it involve CALCULATE ?</P> Mon, 04 Nov 2024 20:26:32 GMT lbendlin 2024-11-04T20:26:32Z https://community.fabric.microsoft.com/t5/Report-Server/Issue-with-DAX-function-SummarizeColumns-Power-BI-Report-Server/m-p/4269159#M38471 <P>We have some report objects that use SummarizeColumns function that are not rendering when executed from the Report Server that we just upgraded to September 2024. The function works correctly when loading the same report, from the RS, using Power BI Desktop Report Server September 2024, as well as Power BI Desktop. Attached screenshot shows the error from the PBIRS, as well as a screenshot showing the graph loading properly in PBI Desktop RS. Is there something missing on our report server for this to render properly? Thanks<img /></P> Mon, 04 Nov 2024 13:01:20 GMT https://community.fabric.microsoft.com/t5/Report-Server/Issue-with-DAX-function-SummarizeColumns-Power-BI-Report-Server/m-p/4269159#M38471 brandonmcg 2024-11-04T13:01:20Z https://community.fabric.microsoft.com/t5/Report-Server/Issue-with-DAX-function-SummarizeColumns-Power-BI-Report-Server/m-p/4269647#M38474 <P>you would need to show more details about your measure. Does it involve CALCULATE ?</P> Mon, 04 Nov 2024 20:26:32 GMT https://community.fabric.microsoft.com/t5/Report-Server/Issue-with-DAX-function-SummarizeColumns-Power-BI-Report-Server/m-p/4269647#M38474 lbendlin 2024-11-04T20:26:32Z https://community.fabric.microsoft.com/t5/Report-Server/Issue-with-DAX-function-SummarizeColumns-Power-BI-Report-Server/m-p/4270668#M38492 <P>The measure is using AVERAGEX that calls SUMMARIZECOLUMNS.<BR /><BR /></P> Tue, 05 Nov 2024 12:12:05 GMT https://community.fabric.microsoft.com/t5/Report-Server/Issue-with-DAX-function-SummarizeColumns-Power-BI-Report-Server/m-p/4270668#M38492 brandonmcg 2024-11-05T12:12:05Z https://community.fabric.microsoft.com/t5/Report-Server/Issue-with-DAX-function-SummarizeColumns-Power-BI-Report-Server/m-p/4270675#M38493 <P>If you have a Pro license you can open a Pro ticket at <A href="https://admin.powerplatform.microsoft.com/newsupportticket/powerbi" target="_blank">https://admin.powerplatform.microsoft.com/newsupportticket/powerbi</A><BR />Otherwise you can raise an issue at <A href="https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues" target="_blank">https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues</A> .</P> Tue, 05 Nov 2024 12:15:50 GMT https://community.fabric.microsoft.com/t5/Report-Server/Issue-with-DAX-function-SummarizeColumns-Power-BI-Report-Server/m-p/4270675#M38493 lbendlin 2024-11-05T12:15:50Z https://community.fabric.microsoft.com/t5/Report-Server/Issue-with-DAX-function-SummarizeColumns-Power-BI-Report-Server/m-p/4270767#M38495 <P>I posted to issues.<BR /><BR />On a side note, I just noticed that the version of DAX libraries installed on my PBI Desktop RS (16.0.148.21) is different than what is installed on with Report Server (16.0.144.18). I am going to see if I can get a sys admin to replace the files on the report server as a test.<BR />Microsoft.AnalysisServices.Dax.Extensions.dll<BR />Microsoft.AnalysisServices.Dax.ExtensionInterfaces.dll</P> Tue, 05 Nov 2024 13:20:13 GMT https://community.fabric.microsoft.com/t5/Report-Server/Issue-with-DAX-function-SummarizeColumns-Power-BI-Report-Server/m-p/4270767#M38495 brandonmcg 2024-11-05T13:20:13Z