Accumulate values in a column

[tmacfrank]

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".

[Anonymous · Accepted solution]

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