Forum Discussion
Matthias93
9 years agoHelper III
Report is too slow
Hi, I currently have a dashboard based on 5 excels and 10 SharePoint lists. To increase the speed of this report I have done mulitple things: Deleted columns I don't need (will it make a diffe...
Anonymous
9 years agoNot applicable
Oh yeah, nesting multiple SUMXs inside a SUMMARIZE will definitely slow things way down, especially if there are a lot of rows in whatever you're SUMXing. As a first step, I would recommend installing DAX Studio and learning how to use that. You can run test queries to find out how quickly or slowly a particular measure will run, which will help you find the major sources of slowdown. Then you can focus on those measures and see if there is a more efficient way to write them. I'll play around with your example measures to see if I can come up with any better methods.
Matthias93
9 years agoHelper III
Thanks, I will have a look at this tool and try to make it more efficient as well.