Forum Discussion
Helper IIIRunning Total Non Date - Not Enough Memory
Helper IIIHi Anonymous, Thank you again and you are right. It looks like I misstyped 350 for 300.
I have tried this method again and am looking into further optimizing my reports. Unfortunately, I am still not able to quickly populate the Running Total Messure and even the Total_Price_Messure takes a great deal of time. The issue may be somewhere else in my file, but these are the only portions of my entire report that has a processing problem with all other messures under 500 ms and the top across all reports less than 1400 ms.
Hi EnrichedUser ,
The speed on power bi Desktop is slow, and the solution seems to be only dax optimization and reduction of useless data. You can also put the data into the SQL server and use Direct Query to input data, which will be faster
You can use DAX Studio to optimize the inspection of DAX statements from a performance perspective and use the Performance analyzer to check the performance of each of your report elements when users interact with them, and which aspects of performance consume the most (or least) resources
This is a link to related content, I hope it will help you:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer
Best Regards,
Liu Yang
- EnrichedUser
I will look into the dax studio.
My guess is going to be that I have to optimize the code for the running total which is what I am looking for: an optimized running total dax solution.Hi EnrichedUser ,
This is the introduction, installation and use of Dax studio. I hope it will help you:
https://powerbi.tips/2020/05/introduction-to-dax-studio/
https://exceleratorbi.com.au/getting-started-dax-studio/
https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.