New measure

Question

Hello;&nbsp;I would like to ask&nbsp;if what&nbsp;Measure can i use to calculate the column WORK CATEGORY for Admin-Work plan and Admin-Work plan (OT) only.&nbsp; Not including the other work category.&nbsp;Request IDUnitResource EIDWork CategoryItemCommentWorked DateWorked Hours2987-0331Team 1Admin-Work planN/AFIO Workplan8/29/20180.502987-0323Team 3Admin-Work plan (OT)N/A&nbsp;8/29/20182.002987-0313Team 5Admin-Work plan (OT)FIO(1-1)&nbsp;8/30/20180.752987-0313Team 6Admin-Work planFIO(1-2)&nbsp;8/30/20180.752987-0341Team 2Admin-Work plan (OT)N/A&nbsp;8/29/20181.002987-0331Team 4Admin-Work planN/AFIO Workplan8/30/20181.002987-0332Team 3Admin-Work planN/A&nbsp;8/30/20182.002987-0312Team 2Admin-Work planFIO(1-1)&nbsp;8/30/20180.752987-0312Team 4Admin-Work planFIO(1-2)&nbsp;8/30/20180.752987-0313Team 5Execution- ExecutionFIO(1-1)&nbsp;8/30/20184.002987-0313Team 6Execution- ExecutionFIO(1-2)&nbsp;8/30/20180.502987-0313Team 1Admin-AdminN/AEmails, Tracker, Unit Tracker Consistency8/30/20181.002987-0321Team 2Execution- Execution (OT)FIO(1-1)&nbsp;8/30/20183.502987-0321Team 3Execution- ExecutionFIO(1-2)&nbsp;8/30/20183.502987-0321Team 4Admin-AdminN/Aemail,tracker8/30/20180.502987-0332Team 5Admin-AdminN/ATracker8/30/20180.502987-0332Team 6Execution- ExecutionFIO(1-1)&nbsp;8/30/20181.002987-0332Team 4Execution- ExecutionFIO(1-2)&nbsp;8/30/20186.502987-0342Team 3Execution- ExecutionFIO(1-1)&nbsp;8/30/20180.502987-0342Team 5Execution- ExecutionFIO(1-2)&nbsp;8/30/20180.502987-0321Team 2Admin-Work planN/A&nbsp;8/30/20182.00

anonymous · Accepted Answer

For example you want to calculate worked hours for Admin-Work plan, you could use this measure:&nbsp;*Measure = 
CALCULATE(SUM(Table[Worked Hours]),&nbsp;FILTER(Table, [Work Category] = "Admin-Work plan"))You could use the same pattern of this Measure for other calculations. Just use CALCULATE and FILTER.

Forum Discussion

New measure

2 Replies

Related content

Measure

DAX Measure

Path Measure

% of total measure

Count Measure

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