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
    )
ThxAlot's avatar
ThxAlot
Icon for Super User rankSuper User
2 years ago

 

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