Cumulative Total without date

[JoanElGran1899]

Hi Everyone,

I'm at an absolute loss as to how to calculate a cumulative total without data.

I tried something like this:

Total acumulado de IMPORTE en date =

CALCULATE(

    [IMPORTE],

    FILTER(

        ALLSELECTED('Dim Calendar'[date]),

        ISONORAFTER('Dim Calendar'[date], MIN('Dim Calendar'[date]), ASC)

    )

)

But was wrong. i need it for General Ledger.

Can someone help me? I will appreciated all your help.

[Fowmy · Accepted solution]

@JoanElGran1899 

Not quite understood the model but can you try the following measure to get the accumulation based on the account number  which I think is 'Cuenta Contable'

Total acumulado GL =
var __acc = MAX(Table1[Cuenta Contable]) return

CALCULATE(
    [IMPORTE],
    FILTER(
        ALLSELECTED(Table1[Cuenta Contable]),
        Table1[Cuenta Contable] <= __acc
    )
)

[JoanElGran1899]

It was exactly what i was looking for! 😉

Thank you so much.