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.

View solution in original post

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.

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 276 members 3,230 guests
Please welcome our newest community members: