cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tmacfrank Frequent Visitor
Frequent Visitor

Accumulate values in a column

Hi,

 

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

 

 

Capture.PNG

 

 

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

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Accumulate values in a column

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 1
Anonymous
Not applicable

Re: Accumulate values in a column

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