Forum Discussion
Dax Query optimization
Hello, Below query is for Total Sum of the positive values in tablur report, working as expected but liitle slow. How to rewrite it in optimize way? Correct Total Sum = SUMX( FILTER( AD...
joepath - I agree with the others that you query is structured well. A small suggestion is to possibly remove "dimA[Aname], dimB[BName]" from the SUMMARIZE function. Instead you could summarize by the FK_A and FK_B on the main fact table. There is a small performance gain in the SUMMARIZE step because the query "may not" need JOINS between the Fact table and DimA and DimB tables. However, this would not work through if "dimA[Aname]" and "dimB[BName]" are sets/groups of many FK_A and FK_B, or when the Filter Context applying to the Fact table is referencing these table anyway.