Forum Discussion

tmacfrank's avatar
tmacfrank
Frequent Visitor
8 years ago
Solved

Accumulate values in a column

Hi,

 

I am trying to accumulate NBIT values in a column like this.

 

 

 

 

Accu_NBIT = CALCULATE(
SUM('Total Distribution All'[NIBT]),
FILTER(
ALL('Total Distribution All'[NIBT]),
'Total Distribution All'[Ranking]< MAX('Total Distribution All'[Ranking])))

 

But it keeps returning the exactly same value withn column "NBIT".

 

 

 

 

 

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi tmacfrank,

     

    Add an Index Column to your table in Query Editor, and then try with this DAX formula to create your column

     

    Accu_NBIT =
CALCULATE (
    SUM ( 'Total Distribution All'[NIBT] ),
    ALL (Total Distribution All),
    'Total Distribution All'[Index]
        <= EARLIER ( 'Total Distribution All'[Index] )
)

    Regards

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi tmacfrank,

     

    Add an Index Column to your table in Query Editor, and then try with this DAX formula to create your column

     

    Accu_NBIT =
CALCULATE (
    SUM ( 'Total Distribution All'[NIBT] ),
    ALL (Total Distribution All),
    'Total Distribution All'[Index]
        <= EARLIER ( 'Total Distribution All'[Index] )
)

    Regards