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(
    sum(itemLedgerEntryPurchase[amount])
    , ALLEXCEPT(itemLedgerEntryPurchase,itemLedgerEntryPurchase[item])
    ,itemLedgerEntryPurchase[Index] <= MAX(itemLedgerEntryPurchase[Index]
))
 

 

Thanx!

 

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
    )

2 Replies

  • 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
    )
  • 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]

    )