Forum Discussion
Need help optimizing DAX with SUMX
Hey everyone, I have a issue where my report is really slow, I think due to my nested measure and my final measure im using which uses the DAX Function SUMX. SAIDI_CIRCUIT_SUM = SUMX(VALUES(...
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.
parry2k
Super User
Super UserAnonymous wow there is a lot more going on, in my opinion it will be easier if you put together sample data and what each measure is doing and what is the end goal, otherwise it is very hard to do reverse engineering