Forum Discussion

Powerwoman's avatar
Powerwoman
Icon for Helper II rankHelper II
2 years ago
Solved

Running Total not working in calculated column

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(   ...
Need Help
  • ThxAlot's avatar
    ThxAlot
    2 years ago

     

    remainingNew =
VAR __idx = itemLedgerEntryPurchase[Index]
RETURN
    CALCULATE(
        SUM( itemLedgerEntryPurchase[amount] ),
        ALLEXCEPT( itemLedgerEntryPurchase, itemLedgerEntryPurchase[item] ),
        itemLedgerEntryPurchase[Index] <= __idx
    )
nirali_arora's avatar
nirali_arora
Icon for Resolver II rankResolver II
2 years ago

You can try the following dax measure

Running Total =

SUMX(

FILTER(

ALL(YourTable),

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

YourTable[ValueColumn]

)