cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vingdelatorre Regular Visitor
Regular Visitor

New measure

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 IDUnitResource EIDWork CategoryItemCommentWorked DateWorked Hours
2987-0331Team 1Admin-Work planN/AFIO Workplan8/29/20180.50
2987-0323Team 3Admin-Work plan (OT)N/A 8/29/20182.00
2987-0313Team 5Admin-Work plan (OT)FIO(1-1) 8/30/20180.75
2987-0313Team 6Admin-Work planFIO(1-2) 8/30/20180.75
2987-0341Team 2Admin-Work plan (OT)N/A 8/29/20181.00
2987-0331Team 4Admin-Work planN/AFIO Workplan8/30/20181.00
2987-0332Team 3Admin-Work planN/A 8/30/20182.00
2987-0312Team 2Admin-Work planFIO(1-1) 8/30/20180.75
2987-0312Team 4Admin-Work planFIO(1-2) 8/30/20180.75
2987-0313Team 5Execution- ExecutionFIO(1-1) 8/30/20184.00
2987-0313Team 6Execution- ExecutionFIO(1-2) 8/30/20180.50
2987-0313Team 1Admin-AdminN/AEmails, Tracker, Unit Tracker Consistency8/30/20181.00
2987-0321Team 2Execution- Execution (OT)FIO(1-1) 8/30/20183.50
2987-0321Team 3Execution- ExecutionFIO(1-2) 8/30/20183.50
2987-0321Team 4Admin-AdminN/Aemail,tracker8/30/20180.50
2987-0332Team 5Admin-AdminN/ATracker8/30/20180.50
2987-0332Team 6Execution- ExecutionFIO(1-1) 8/30/20181.00
2987-0332Team 4Execution- ExecutionFIO(1-2) 8/30/20186.50
2987-0342Team 3Execution- ExecutionFIO(1-1) 8/30/20180.50
2987-0342Team 5Execution- ExecutionFIO(1-2) 8/30/20180.50
2987-0321Team 2Admin-Work planN/A 8/30/20182.00
1 ACCEPTED SOLUTION

Accepted Solutions
jenelrosales Regular Visitor
Regular Visitor

Re: New measure

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.

2 REPLIES 2
jenelrosales Regular Visitor
Regular Visitor

Re: New measure

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

jenelrosales Regular Visitor
Regular Visitor

Re: New measure

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.