Forum Discussion
Power BI Running Total Memory fault
- 2 years ago
jpdejongjr great suggestion by DataInsights on Visual Calculation but keep in mind it will only work within those visuals. If you want to use it elsewhere you need to add measures, check this video on my channel and see if it helps How new WINDOW DAX functions and PARTITIONBY helped to get the running total in Power BI - Part 2 (youtube.com)
Have you tried visual calculations (link below)? This is a new feature that can be more performant than traditional ways of calculating running totals. Depending on your model, another option is to push the running total logic as far upstream as possible (SQL --> Power Query --> DAX calculated column); this approach won't recognize user filters, however.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview