Sum base from two Column

[AllanBerces]

Hi good day can anyone help me on my calculated column. On my table i want to the sum of Required base from Plan No. and Job No. column 

Sample - Plan No. 1001213651 with Job No. 22814282 it has a value of 4, 4, 4 and 20 = Total Required is 32

OUTPUT

Job No.	Plan No.	Required	Total Required
22814282	Object	0	0
22814282	Object	0	0
22814282	Object	0	0
22814282	1001182801	0	0
22814282	1001158071	0	0
22814282	1000957704	0	0
22814282	1000254170	0	0
22814282	1002880208	0.08	0.08
22814282	1002845288	8	8
22814282	1001213652	4	4
22814282	1001213651	4	32
22814282	1001213651	4	32
22814282	1001213651	4	32
22814282	1001213651	20	32
22814282	1000283298	2	2
22814282	1000282395	3	3
22814282	1000257696	3	3
22814282	1000064371	1	1
22814282	1000064370	4	7
22814282	1000064370	1	7
22814282	1000064370	1	7
22814282	1000064370	1	7
23118955	Object	0	0
23118955	Object	0	0
23118955	1000284341	48	48
23118955	Object	0	0
23118955	Object	0	0
23118955	1000258179	1	1
23118955	1001265835	0	0
23118955	1001265835	0	0
23118955	1001898313	0	0
23118955	1000283298	0	0

[ryan_mayu · Accepted solution]

@AllanBerces 

you can try this

Column = CALCULATE(sum(job[Required]),ALLEXCEPT(job,job[Job No.],job[Plan No.]))

pls see the attachment below

[AllanBerces]

Hi @ryan_mayu Thnak you very much work as i need

[ryan_mayu]

you are welcome