Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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.
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.
What do you want to calculate in particular? Sum of worked hours?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |