New measure

[Anonymous]

Hello;

I would like to ask if what Measure can i use to calculate the column WORK CATEGORY for Admin-Work plan and Admin-Work plan (OT) only.  Not including the other work category.

Request ID	Unit	Resource EID	Work Category	Item	Comment	Worked Date	Worked Hours
2987-03	31	Team 1	Admin-Work plan	N/A	FIO Workplan	8/29/2018	0.50
2987-03	23	Team 3	Admin-Work plan (OT)	N/A		8/29/2018	2.00
2987-03	13	Team 5	Admin-Work plan (OT)	FIO(1-1)		8/30/2018	0.75
2987-03	13	Team 6	Admin-Work plan	FIO(1-2)		8/30/2018	0.75
2987-03	41	Team 2	Admin-Work plan (OT)	N/A		8/29/2018	1.00
2987-03	31	Team 4	Admin-Work plan	N/A	FIO Workplan	8/30/2018	1.00
2987-03	32	Team 3	Admin-Work plan	N/A		8/30/2018	2.00
2987-03	12	Team 2	Admin-Work plan	FIO(1-1)		8/30/2018	0.75
2987-03	12	Team 4	Admin-Work plan	FIO(1-2)		8/30/2018	0.75
2987-03	13	Team 5	Execution- Execution	FIO(1-1)		8/30/2018	4.00
2987-03	13	Team 6	Execution- Execution	FIO(1-2)		8/30/2018	0.50
2987-03	13	Team 1	Admin-Admin	N/A	Emails, Tracker, Unit Tracker Consistency	8/30/2018	1.00
2987-03	21	Team 2	Execution- Execution (OT)	FIO(1-1)		8/30/2018	3.50
2987-03	21	Team 3	Execution- Execution	FIO(1-2)		8/30/2018	3.50
2987-03	21	Team 4	Admin-Admin	N/A	email,tracker	8/30/2018	0.50
2987-03	32	Team 5	Admin-Admin	N/A	Tracker	8/30/2018	0.50
2987-03	32	Team 6	Execution- Execution	FIO(1-1)		8/30/2018	1.00
2987-03	32	Team 4	Execution- Execution	FIO(1-2)		8/30/2018	6.50
2987-03	42	Team 3	Execution- Execution	FIO(1-1)		8/30/2018	0.50
2987-03	42	Team 5	Execution- Execution	FIO(1-2)		8/30/2018	0.50
2987-03	21	Team 2	Admin-Work plan	N/A		8/30/2018	2.00

[Anonymous · Accepted solution]

For example you want to calculate worked hours for Admin-Work plan, you could use this measure:

*Measure = 
CALCULATE(SUM(Table[Worked Hours]), FILTER(Table, [Work Category] = "Admin-Work plan"))

You could use the same pattern of this Measure for other calculations. Just use CALCULATE and FILTER.

[Anonymous]

What do you want to calculate in particular? Sum of worked hours?