Running Total not working in calculated column

[Powerwoman]

Hi there,

can anyone tell me, why this DAX isn't working but always showing the total instead of running total?
Running totals should be calculated by item.

remainingNew =

 CALCULATE(

    sum(itemLedgerEntryPurchase[amount])

    , ALLEXCEPT(itemLedgerEntryPurchase,itemLedgerEntryPurchase[item])

    ,itemLedgerEntryPurchase[Index] <= MAX(itemLedgerEntryPurchase[Index]

))

Thanx!

[nirali_arora]

You can try the following dax measure

Running Total =

SUMX(

FILTER(

ALL(YourTable),

YourTable[Index] <= MAX(YourTable[Index]) ),

YourTable[ValueColumn]

)

[ThxAlot · Accepted solution]

remainingNew =
VAR __idx = itemLedgerEntryPurchase[Index]
RETURN
    CALCULATE(
        SUM( itemLedgerEntryPurchase[amount] ),
        ALLEXCEPT( itemLedgerEntryPurchase, itemLedgerEntryPurchase[item] ),
        itemLedgerEntryPurchase[Index] <= __idx
    )