Forum Discussion
Helper IIIRunning Total Non Date - Not Enough Memory
Super UserHi,
These are the measures i wrote
Price = SUM(Data[Total Price])Rank by price of Sales order = if(HASONEVALUE(Data[SalesOrderID]),RANKX(ALL(Data[SalesOrderID]),[Price]),BLANK())Cumulative price = SUMX(TOPN([Rank by price of Sales order],CALCULATETABLE(VALUES(Data[SalesOrderID]),ALL(Data[SalesOrderID])),[Price],DESC),[Price])Hope this helps.
Helper III
Thank you for your time and quick reply. I spent a while this today working through this one. Sadly, I was not able to use as it still took too long to run.
I think the primary issue is that, I am only considering about 10k rows that are open and need to filter out the other 1m.
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.
- EnrichedUser
Hi 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