Forum Discussion
Query Taking over 15 Seconds
Hello All, I have inherited a report and am trying to optimize it for better performance. The query below is taking over 15 seconds. The tile is a Matrix. I will greatly appreciate your sugges...
Hi Anonymous
The SummarizeColumns() function can slow down Measure dramatically.
The measure is calculating dynamically, everytime you refresh the visual, it will re-run the whole flow.
Maybe you can consider change the variable __DS0Core into a real table, so that can greatly increase the speed.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.