power Bi Matrix-add total in same column

[ABC11]

Hello,

I have matrix -under column - SITEID-"ALBIAN" "HORIZON"  and LABORPAYCODE has lots. such as 801,802,814,809,826.... only 801 paycode represent for Regular time all other represent Overtime. I need have one column for regular time and one for overtime. In order to calculate overtime I need to add all paycode except 801. 

SITEID	LaborPayCode
ALBIAN	ALBIAN	ALBIAN	ALBIAN	HORIZON	HORIZON	HORIZON	HORIZON	Grand Total
801	802	814	830	801	802	814	830
				620			24	644
				576		14.5	24	614.5
702		113	24					839
28	8			268	152	6.5	36	498.5
11								11
324		1						325
505			24					529
36				156	48	1.5		241.5
720		1	36			96.5	24	877.5
32	45	2.5		8	4	2		93.5
456		186	36					678
72								72
80	52	1						133
8	4			696		98.5	24	830.5
4	12							16
96	48	1		188	134		12	479
708		79	36					823
92	28			86	36		24	266
96	85	8.5		48		1.5		239
6				4	8			18
				590	40	25	36	691
72	24	1						97
192			24	162			27	405
36	24			460	144	2	36	702
				760	56	2	24	842
40	8	1.5		392	112	1.5	12	567
660			24					684
				133	76	1	12	222
				504			24	528

Thanks,

ABC

[ABC11]

Hello Serpiva64,

Thanks for your time. This will put togather only paycode. I would like to add overtime base on laborpaycode. This is matrix table. Only 801 paycode is for Regulatime. 802,814,830 all these are represent ovetime hrs.

		SITEID	LaborPayCode
		ALBIAN	ALBIAN	ALBIAN	ALBIAN		HORIZON	HORIZON	HORIZON	HORIZON
Employee name	Employee NO	801	802	814	830	Total	801	802	814	830	Total
Tara	30000						620			24	644
Mita	30001						576		14.5	24	614.5
Ryan	30002	702		113	24	137
Dinah	30003	28	8			8	268	152	6.5	36	462.5
Kim	30004	11
Reena	30005	324		1		1
Nola	30006	505			24	24
Farah	30007	36					156	48	1.5		205.5
Dylan	30008	720		1	36	37			96.5	24	120.5
Mike	30009	32	45	2.5		47.5	8	4	2		14
Rose	30010	456		186	36	222
Neail	30011	72
Jit	30012	80	52	1		53

 My output should be 

Employee name	Employee NO	Horizon Regular time	Horizon Overtime	Horizon Total time	Albian Regulartime	Albian Overtime	Albian TotalTime
Tara	30000	620	24	644		137	137
Mita	30001	576	38.5	614.5		8	8
Ryan	30002				702		702
Dinah	30003	268	194.5	462.5	28	1	29
Kim	30004				11	24	35
Reena	30005				324		324
Nola	30006				505	37	542
Farah	30007	156	49.5	205.5	36	47.5	83.5
Dylan	30008		120.5	120.5	720	222	942
Mike	30009	8	6	14	32		32
Rose	30010				456	53	509
Neail	30011				72		72
Jit	30012				80		80

[v-easonf-msft · Accepted solution]

Hi, @ABC11 

You can  add a new calculated column 'Lable Time' to replace your original field 'LaborPayCode' in your matrix visual.

Lable Time = IF('Table'[LaborPayCode]=801,"1Refgular time","2Over Time")

Please check my sample file for more details.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[serpiva64]

Hi,

in your table you select column Laborpaycode and group it this way

and then in your visual you use the groupd column instead of Laborpaycode

If this post is useful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !