Forum Discussion
Helper IIIRunning Total Non Date - Not Enough Memory
Hi EnrichedUser ,
The total is incorrect because my sample data S102 is 300 when it is Open, not 350Change the sample data and enter the above formula. The result is:
You can use our formula to compare the loading time
The loading time is too long. You can optimize the Dax function to reduce useless data and clear the Dax cache. For details, you can check these links:
https://maqsoftware.com/expertise/powerbi/dax-best-practices
https://powerpivotpro.com/2019/03/dax-optimizations-write-it-like-the-dax-calls-it/
You can downloaded PBIX file from here.
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.
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.