cumulative calculation DAX

[HuubKW]

I made a DAX formula for camulative calculations.

See dax formula

Cumulatieve Berekening =

CALCULATE(

    SUM('Grootboekmutaties huidig jaar'[Saldo]),

    FILTER(

        ALLSELECTED('Grootboekmutaties huidig jaar'[Omschrijving]),

        'Grootboekmutaties huidig jaar'[Omschrijving] <= MAX('Grootboekmutaties huidig jaar'[Omschrijving])

    )

)

It shows all incoming and outgoing transactions. In the other column the transactions calculates calmulatively due to the DAX formula I made. I made a table with date, incoming and outgoing transactions, transaction_ID and camulative calculation. The problem is when you jump from April 1 to April 2, the camulative calculation starts over again. Does somebody know the solution to this problem?
See example.

Date	Transaction_id	Transactions	Camulative_calculation
01-april	1	50	50
01-april	2	-80	-30
01-april	3	210	180
02-april	4	80	80
02-april	5	50	130
02-april	6	100	230

[tamerj1]

Hi @HuubKW 
Date is from which table? What happens if you remove it from the visual?

[HuubKW]

When i remove the Date column from the visual it works, but i need to include the date column.

[tamerj1 · Accepted solution]

@HuubKW 
Please try

Cumulatieve Berekening =
CALCULATE (
    SUM ( 'Grootboekmutaties huidig jaar'[Saldo] ),
    FILTER (
        ALLSELECTED ( 'Grootboekmutaties huidig jaar'[Omschrijving] ),
        'Grootboekmutaties huidig jaar'[Omschrijving]
            <= MAX ( 'Grootboekmutaties huidig jaar'[Omschrijving] )
    ),
    ALL ( 'Table'[Date] )
)

[HuubKW]

Thank you, this one works