if sum of total is negative add to this week else no

[Anonymous]

hello i have a table

say for initial month 1:

Name	Pay	Previous Pay	Total Pay
A	1000		1000
B	-2000		-2000
C	-1000		-1000
Total	-2000		-2000

and if i select month 2:

Name	Pay	Previous Pay	Total Pay
A	500	1000	1500
B	3000	-2000	1000
C	4000	-1000	3000
Total	7500	-2000	5500

measure is :

Pay = sum([pay])

previous pay = calculate([pay],previousmonth)

total pay = if([previous pay] < 0 ,[pay]+[previous pay],[pay])

when i do this measure, it only affects the negative numbers and i get this:

Name	Pay	Previous Pay	Total Pay
A	500	1000	500
B	3000	-2000	1000
C	4000	-1000	3000
Total	7500	-2000	4500

so how can i say if total of [previous pay] < 0 then add previous with current pay

but this isnt my desired result:

my desired result is the thrid table which is this:

Name	Pay	Previous Pay	Total Pay
A	500	1000	1500
B	3000	-2000	1000
C	4000	-1000	3000
Total	7500	-2000	5500

[amitchandak · Accepted solution]

@Anonymous , change the measure like

total pay =
sumx(Values(Table[Name]), if([previous pay] < 0 ,[pay]+[previous pay],[pay]))