Running total not working - skips some values

[AnaPiedade]

I am trying to do a running total from an amount column, but for some reason sometimes I get the same value on the running total column (as in the pictures). I have tried a million things and nothing seems to work. I am completely new at Power BI.

These are my measures:

TotalInvoiced(€) = SUM(Table[Invoiced Amount(€)])

Spend RunningTotal =
IF(
    NOT(ISBLANK([TotalInvoiced(€)])),
    CALCULATE(
        [TotalInvoiced(€)],
        FILTER(
            ALL(Table[Vendor]),
            SUM(Table[Invoiced Amount(€)]) <= [TotalInvoiced(€)] )))

What am I doing wrong?

[Anonymous]

Running totals are usually written for the time dimension, not any other. If you want to write a RT against a different dimension, then you have to have a sort order defined. For any particular cell in your table, The FILTER in your formula filters vendors whose Invoiced Amount is less than or equal to the current vendor's Invoiced Amount. This, of course, will not correspond to the order of vendors.

Best
D