Forum Discussion
Need Assistance Optimizing DAX Statement
The below DAX statement is extremely slow (and sometimes exceeds resource limits), and I'm not sure how to optimize its speed. Does anyone have any tips on how this could be written more effeciently?...
Greg_Deckler
Community Champion
Community ChampionI have a whole blog series on performance tuning DAX: https://community.powerbi.com/t5/Community-Blog/Performance-Tuning-DAX-Part-1/ba-p/976275
You probably don't need the VALUES statement so ditch it because it is costing you performance. Otherwise, probably need to understand what that measure is doing (it's formula)