Forum Discussion
Optimising a DAX
Hello Community, I have DAX here which is needed some optimisation. In the sense at the moment whhen I'm using this DAX in visualisation it's taking a lot of time/memory to load. Any suggestions...
littlemojopuppy
Community Champion
Community ChampionAnonymous you are making extensive use of the SUMMARIZE function, which has performance issues. I'd suggest rewriting to use some combination of GROUPBY and ADDCOLUMNS. Hope this helps!