Accumulative measure - any ideas

[Casperserven1]

Hi - I am trying to produce a canaluclated measure to do the following:

This is my data table:

Turn	NewHires	Retirees	NHmRE
0	0	0	0
1	2	4	-2
2	6	1	5
3	4	2	2
4	6	5	1
5	3	1	2

And this is the result I am trying to achieve using a measure

Turn	NewHires	Retirees	NHmRE	Workforce
0	0	0	0	22
1	2	4	-2	20
2	6	1	5	25
3	4	2	2	27
4	6	5	1	28
5	3	1	2	30

My starting workforce is 22 and then at every turn it then takes the previous turn workforce total and add NHmRE to give the running total.
e.g Turn 1 Workforce = Turn 0 Workforce (22) + Turn 1 NHmRE (-2)  which gives 20

      Turn 2 Workforce = Turn 1 Workforce (20) + Turn 2 NHmRE (5)  which gives 25

I have posted this previously but the solution given was using calculated columns. I need a measure .... any ideas ?

[johnt75]

You could try

Workforce =
VAR StartingNumber = 22
VAR CurrentTurn =
    SELECTEDVALUE ( 'Table'[Turn] )
VAR CumulativeChanges =
    CALCULATE (
        SUM ( 'Table'[NHmRE] ),
        REMOVEFILTERS ( 'Table' ),
        'Table'[Turn] <= CurrentTurn
    )
VAR Result = StartingNumber + CumulativeChanges
RETURN
    Result

[Casperserven1 · Accepted solution]

Thank you so much @johnt75 Had to tweak the solution because the actual data looks like this:
CourseDateTurnTableNew HiresTotal WorkforceRetirees

01 April 2016	1	Red	2	21	3
01 April 2016	2	Red	2	21	2
01 April 2016	3	Red	2	21	2
01 April 2016	4	Red	2	20	3
01 April 2016	5	Red	2	19	3
01 April 2016	1	Lilac	2	21	3
01 April 2016	2	Lilac	2	20	3
01 April 2016	3	Lilac	1	19	2
01 April 2016	4	Lilac	1	17	3
01 April 2016	5	Lilac	2	16	3
01 April 2016	1	Green	2	21	3
01 April 2016	2	Green	2	20	3
01 April 2016	3	Green	2	20	2
01 April 2016	4	Green	2	19	3
01 April 2016	5	Green	2	19	2
01 April 2016	1	Blue	2	21	3
01 April 2016	2	Blue	2	20	3
01 April 2016	3	Blue	2	20	2
01 April 2016	4	Blue	2	19	3
01 April 2016	5	Blue	2	18	3
01 April 2016	1	Black	2	21	3
01 April 2016	2	Black	2	20	3
01 April 2016	3	Black	0	18	2
01 April 2016	4	Black	1	18	1
01 April 2016	5	Black	2	16	4