IsGrandTotalRowTotal

[sbkrishblr]

Hi,

We are auditing all the DAX queries generated by Power BI and hitting the source SSAS tabular cubes using extended events in SSAS server.

we were seeing few queries taking longer time for a particular data grid visual which had a measure and few attributes from couple of entities. we used a TOP N filter to restrict number of records in the data grid visual.

then we observed the dax query did not contain - IsGrandTotalRowTotal even though the data grid in that specific report had TOTAL row.

But when we tried to capture the same dax query using Power BI Desktop & SQL Server profiler, it did contain the IsGrandTotalRowTotal and DAX query executed very quickly, we executed the captured DAX query in DAX studio.

what would be the reason the DAX query which was captured during logging did not have the IsGrandTotalRowTotal ?

the audited DAX query from extended events(long running query) :

EVALUATE
TOPN (
    150002,
    SUMMARIZECOLUMNS (

the DAX query captured from SQL profiler( this runs very fast)

EVALUATE
  TOPN(
    502,

   SUMMARIZECOLUMNS(
      ROLLUPADDISSUBTOTAL(
        ROLLUPGROUP(

Thanks,

Suresh K
  

[v-jiascu-msft]

Hi Suresh,

Does "ROLLUPADDISSUBTOTAL" in the DAX formula return total? Please refer to dax/summarizecolumns-function-dax.

Best Regards,

Dale