Forum Discussion

lmb218's avatar
lmb218
New Member
11 months ago
Solved

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 ...
Need Help
  • lmb218's avatar
    lmb218
    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
    )
)
v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
11 months ago

Hi lmb218,

Hope you had a chance to try out the solution shared earlier. Let us know if anything needs further clarification or if there's an update from your side always here to help.

Thank you.

v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
11 months ago

Hi lmb218,

Just wanted to follow up one last time. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.