Running total without date,rank

[Iamnvt]

hi,

How can I write a measure to get the running total for this below case? I know how to write for a calculated column, just wondering how it will be with a measure.

Thanks

Column1	Column3	ExpectedResult
A	2	2
A	3	5
A	1	6
B	3	3
B	4	7
B	5	12
B	6	18

[Melvlee]

Hi there,

Have you tried the quick measures feature?

Please refer to Quick Measures

Regards

[Anonymous]

Hi @Iamnvt,

The quickmeasure as suggested @Melvlee will not work because it will reset at every row of Column1.

The method suggested by @Ashish_Mathur will compute but will fail in display.  The rows will not be displayed in the same order as original data table.

If you want the values to be displayed in the same order as your input data you will have to bring in the index column defined in the excel work sheet by @Ashish_Mathur and sort in the table display by index column.

If this works for you please accept @Ashish_Mathur suggestion as a solution and do give KUDOS to me as well.

Cheers

CheenuSing

[Iamnvt]

hey, I want to write a MEASURE (Calculated field), not a Calculated column.

is there any solution for that?

[Anonymous · Accepted solution]

Hi @Iamnvt

Here you go.

RunningTotal Measure = CALCULATE(
SUM( MovingSum[Column2]),
FILTER(  ALL(MovingSum) ,
SUMX( FILTER( MovingSum, EARLIER( MovingSum[Column1] ) = MovingSum[Column1] && EARLIER(MovingSum[Index]) <= MovingSum[Index] ), MovingSum[Column2] )
)
)

This assumes you have created an index column using query editor.

If this works for you please accept this as a solution and also give KUDOS.

Cheers

CheenuSing

[Ashish_Mathur]

Hi,

I am assuming that you want to ccreate a calculated column formula.  If that be the case, you may refer to my solution here.  Go the Data Model to see the result.