Forum Discussion
Need help optimizing DAX with SUMX
Anonymous - I'm with parry2k DAX performance issues are notoriously difficult to troubleshoot. See my blog article series here:
https://community.powerbi.com/t5/Community-Blog/Performance-Tuning-DAX-Part-1/ba-p/976275
I would say if you don't really need that VALUES statement, ditch it. A lot of people use that function when they don't need to and it costs them performance.
Community ChampionAnonymous - I'm with parry2k DAX performance issues are notoriously difficult to troubleshoot. See my blog article series here:
https://community.powerbi.com/t5/Community-Blog/Performance-Tuning-DAX-Part-1/ba-p/976275
I would say if you don't really need that VALUES statement, ditch it. A lot of people use that function when they don't need to and it costs them performance.
Thanks for feedback, I will try to explain more details when I post in the future. Actually, my problem is solved, teamates and I will just move these measure in the backend in the calculated tables itself - thanks!