Forum Discussion

RenateBK's avatar
RenateBK
Icon for Helper II rankHelper II
3 years ago
Solved

Need help: Cumulative sum function only returns total

Hello,    Edit: Along with the solution I also identified another mistake I made. There was a mismatch between the formatting of my date table and the date column in my fact table (date/time vs dat...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi Renate,

     

    Try this as a measure instead, making sure to use dDato fields in visuals, not fact table dates:

    _cumulativeSum =
VAR __cDate = MAX(dDato[Date])
RETURN
CALCULATE(
    SUM(OversiktKurs[Deltagere kurs]),
    FILTER(
        ALLSELECTED(dDato),
        dDato[Date] <= __cDate
    )
)

     

    Pete

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
3 years ago

 

Are you trying to create this as a calculated column rather than a measure?

You shouln't get a circular dependency when creating a measure as your dDato table would not get recalculated at thatpoint.

 

Pete

RenateBK's avatar
RenateBK
Icon for Helper II rankHelper II
3 years ago

You are correct, it completely slipped my mind.

It worked now, thank you so much for your help. 

 

Best regards, 

Renate