Forum Discussion
lmb218
11 months agoNew Member
Error fetching data for this visual - Running sum
I have a report with a number of visualisations in it. Some of them are line charts with a running sum calculation. The underlying data is from Excel tables stored in SharePoint. In the Desktop ...
- 11 months ago
Thank you for the suggestions. I ended up scrapping using running totals for the visuals. Instead I used a measure to calculate the cumulative totals, and used that in the visuals instead. It works perfectly now.
Cumulative Applications AY = VAR CurrentAY = SELECTEDVALUE(StudentMIData[Academic Year]) VAR CurrentMonth = MAX(AcademicMonthsScaffold[Academic Month Number]) RETURN CALCULATE( [Applications], FILTER( ALLSELECTED(StudentMIData), StudentMIData[Academic Year] = CurrentAY && StudentMIData[Academic Month Number] <= CurrentMonth ) )