Running totals causing visuals to exceed limit of memory and crash.

[CarlSagan]

I have a report that has multiple pages using running totals (same ones multiple times). In this report, the visuals were loading and working at one point in time and now they exceed the limit and none of them are loading. I created another power bi project to see if the visual would work if I only had one page and it did. 

• Does a report with multiple pages cause the project to get bloated with computation and cause slowdowns? As in, when I'm looking at one page, do the other inactive pages have an effect on the active page?
• Are there ways to reuse running total columns to speed up the visual so it doesn't crash? How can I tell if it's the size of the data set or my algorithm that is the main culprit?
• Why do the same visuals crash in one project but work in another?

[v-cgao-msft]

Hi @CarlSagan ,

A report with multiple pages can cause the project to get bloated with computation and cause slowdowns. When you are looking at one page, the other inactive pages do not have an effect on the active page. There are ways to reuse running total columns to speed up the visual so it doesn't crash. You can use the Performance Analyzer tool included in Power BI Desktop to identify visuals that are impacting the performance of a report, and identify the reason for the impact.

To determine if it's the size of the data set or your algorithm that is the main culprit, you can use the Performance Analyser tool to collect the related json file which will contain the load time for each one of the visuals and identify the bottleneck. You can also use DAX Studio to test DAX queries that the customer is using and study their performance.

Importing Performance Analyzer data into DAX Studio - SQLBI

The third question is to be analyzed based on differences in data sets or environments. Regarding the measures, You can use the Performance Analyzer tool to identify which visual is causing the issue, and identifies which aspects of the visual is taking the longest duration to process.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[ToddChitt]

How are you implementing the Running Totals? In DAX or Power Query? Can you show us your code, and maybe a snippet of your data?

[CarlSagan]

Here are some examples of the code in dax

Last Contributions = 

VAR mostRecentMonth = LASTDATE(Assets[process_period_date])
VAR prevMonth = PREVIOUSMONTH(mostRecentMonth)
var result = CALCULATE(
                SUM(Assets[amount]),
                Assets[tran_code] = 101 ||
                Assets[tran_code] = 102 ||
                Assets[tran_code] = 103 ||
                Assets[tran_code] = 109 ||
                Assets[tran_code] = 133,
                Assets[process_period_date] = mostRecentMonth
)
RETURN result

Beginning Balance = 
VAR lastD = LASTDATE(Assets[process_period_date])
var lastM = MONTH(lastD)
VAR prevM = PREVIOUSMONTH(lastD)

var begBal = CALCULATE(
                SUM(Assets[amount]),
                Assets[process_period_date] <= prevM
)

RETURN begBal

Then a measure that is using all the running total measures in one expression

Last Ending Balance = 
    [Beginning Balance] + [Last Earnings] + [Last Expenses] + [Last Distribution] + [Last Contributions] + [Last Transfer Total]

Here is an example output I am trying to get (filtering to one row to show you what it looks like)