https://community.fabric.microsoft.com/t5/Report-Server/PowerBI-Report-Deleting-some-code-on-DAX-Query-generated-from/m-p/2231266#M22140 <P>The basic approach is that you want to keep the SUMMARIZECOLUMNS call inside the TOPN. If you use a tool like DAX Studio <A href="https://daxstudio.org" target="_blank">https://daxstudio.org</A>&nbsp;or some other text editor which can do bracket highlighting you can then easily see where the call to SUMMARIZECOLUMNS ends and then you would just remove the bits of code before and after that (the items in red boxes below</P> <P><img /></P> <P>&nbsp;</P> Thu, 09 Dec 2021 22:25:33 GMT d_gosbell 2021-12-09T22:25:33Z https://community.fabric.microsoft.com/t5/Report-Server/PowerBI-Report-Deleting-some-code-on-DAX-Query-generated-from/m-p/2229487#M22126 <P>Hi</P><P>I have a DAXquery generated from Performance analyzer. it is restricting the number of records to 501 and inned to removed this and also how could I removed the sub toital and grand total from this script. I tried to delete some code but i'm getting an error. Not able to identify the exact code that i should be removed. Thank you.&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">DEFINE VAR __DS0FilterTable = TREATAS({2021}, 'DateTable'[Received]) VAR __DS0FilterTable2 = TREATAS({"November"}, 'CCST'[MonthName]) VAR __DS0FilterTable3 = TREATAS({"LEGACY"}, 'CCST'[Model]) VAR __DS0FilterTable4 = TREATAS({"DIY"}, 'CCST'[Type]) VAR __DS0FilterTable5 = TREATAS({"Normal"}, 'CCST'[Status]) VAR __DS0FilterTable6 = TREATAS({"OTHERS"}, 'CCST'[Category]) EVALUATE TOPN( 501, SUMMARIZECOLUMNS( ROLLUPADDISSUBTOTAL( 'LocalDateTable_9a516b7e-ac4d-49d6-a22c-5318bf076cd8'[Year], "IsGrandTotalRowTotal", ROLLUPGROUP( 'LocalDateTable_9a516b7e-ac4d-49d6-a22c-5318bf076cd8'[Month], 'LocalDateTable_9a516b7e-ac4d-49d6-a22c-5318bf076cd8'[MonthNo] ), "IsDM0Total" ), __DS0FilterTable, __DS0FilterTable2, __DS0FilterTable3, __DS0FilterTable4, __DS0FilterTable5, __DS0FilterTable6, "SumReceived", CALCULATE(SUM('CCST'[Qty])), "Good", 'CCST'[Good], "Good__", 'CCST'[Good %] ), [IsGrandTotalRowTotal], 1, 'LocalDateTable_9a516b7e-ac4d-49d6-a22c-5318bf076cd8'[Year], 1, [IsDM0Total], 1, 'LocalDateTable_9a516b7e-ac4d-49d6-a22c-5318bf076cd8'[MonthNo], 1, 'LocalDateTable_9a516b7e-ac4d-49d6-a22c-5318bf076cd8'[Month], 1 ) ORDER BY [IsGrandTotalRowTotal], 'LocalDateTable_9a516b7e-ac4d-49d6-a22c-5318bf076cd8'[Year], [IsDM0Total], 'LocalDateTable_9a516b7e-ac4d-49d6-a22c-5318bf076cd8'[MonthNo], 'LocalDateTable_9a516b7e-ac4d-49d6-a22c-5318bf076cd8'[Month]</LI-CODE><P>&nbsp;</P> Thu, 09 Dec 2021 06:30:35 GMT https://community.fabric.microsoft.com/t5/Report-Server/PowerBI-Report-Deleting-some-code-on-DAX-Query-generated-from/m-p/2229487#M22126 Anonymous 2021-12-09T06:30:35Z https://community.fabric.microsoft.com/t5/Report-Server/PowerBI-Report-Deleting-some-code-on-DAX-Query-generated-from/m-p/2231266#M22140 <P>The basic approach is that you want to keep the SUMMARIZECOLUMNS call inside the TOPN. If you use a tool like DAX Studio <A href="https://daxstudio.org" target="_blank">https://daxstudio.org</A>&nbsp;or some other text editor which can do bracket highlighting you can then easily see where the call to SUMMARIZECOLUMNS ends and then you would just remove the bits of code before and after that (the items in red boxes below</P> <P><img /></P> <P>&nbsp;</P> Thu, 09 Dec 2021 22:25:33 GMT https://community.fabric.microsoft.com/t5/Report-Server/PowerBI-Report-Deleting-some-code-on-DAX-Query-generated-from/m-p/2231266#M22140 d_gosbell 2021-12-09T22:25:33Z https://community.fabric.microsoft.com/t5/Report-Server/PowerBI-Report-Deleting-some-code-on-DAX-Query-generated-from/m-p/2231404#M22144 <P>Thank you very much. I'm using notepad++ text editor.</P> Fri, 10 Dec 2021 00:58:03 GMT https://community.fabric.microsoft.com/t5/Report-Server/PowerBI-Report-Deleting-some-code-on-DAX-Query-generated-from/m-p/2231404#M22144 Anonymous 2021-12-10T00:58:03Z