Forum Discussion
Solved
help needed with a measure
Hi All, I am looking for a measure in power BI desktop that will allow me create a sum of various rows based on specific criteria. The criteria being the name of employee and the start of week d...
Try
Column = CALCULATE(SUM(Table[hours worked]), ALLEXCEPT(Table, Table[Employee], Table[start of week date]))
EDIT: I'm a bit confused, do you want a measure or a column?
had a typo with the dates, here is the right sample
| Employee | start of week date | Assignment name | Type of assignment | hours worked | employment type | Total Hours | Total Overhead | Total Hours Adjusted |
| X | Sunday july 3, 2016 | a | Not Overhead | 18 | exempt | 39 | 9 | 39 |
| X | Sunday july 3, 2016 | overhead | Overhead | 9 | exempt | 39 | 9 | 39 |
| X | Sunday july 3, 2016 | b | Not Overhead | 0 | exempt | 39 | 9 | 39 |
| X | Sunday july 3, 2016 | c | Not Overhead | 12 | exempt | 39 | 9 | 39 |
| X | Sunday july 10, 2016 | a | Not Overhead | 18 | exempt | 40 | 9 | 40 |
| X | Sunday july 10, 2016 | overhead | Overhead | 9 | exempt | 40 | 9 | 40 |
| X | Sunday july 10, 2016 | b | Not Overhead | 0 | exempt | 40 | 9 | 40 |
| X | Sunday july 10, 2016 | c | Not Overhead | 13 | exempt | 40 | 9 | 40 |
| X | Sunday july 17, 2016 | a | Not Overhead | 18 | exempt | 54 | 23 | 40 |
| X | Sunday july 17, 2016 | overhead | Overhead | 9 | exempt | 54 | 23 | 40 |
| X | Sunday july 17, 2016 | b | Not Overhead | 0 | exempt | 54 | 23 | 40 |
| X | Sunday july 17, 2016 | c | Not Overhead | 13 | exempt | 54 | 23 | 40 |
| X | Sunday july 17, 2016 | overhead | Overhead | 14 | exempt | 54 | 23 | 40 |
| Y | Sunday july 3, 2016 | a | Not Overhead | 18 | Non - Exempt (Hourly) | 39 | 9 | 39 |
| Y | Sunday july 3, 2016 | overhead | Overhead | 9 | Non - Exempt (Hourly) | 39 | 9 | 39 |
| Y | Sunday july 3, 2016 | b | Not Overhead | 0 | Non - Exempt (Hourly) | 39 | 9 | 39 |
| Y | Sunday july 3, 2016 | c | Not Overhead | 12 | Non - Exempt (Hourly) | 39 | 9 | 39 |
| Y | Sunday july 10, 2016 | a | Not Overhead | 18 | Non - Exempt (Hourly) | 40 | 9 | 40 |
| Y | Sunday july 10, 2016 | overhead | Overhead | 9 | Non - Exempt (Hourly) | 40 | 9 | 40 |
| Y | Sunday july 10, 2016 | b | Not Overhead | 0 | Non - Exempt (Hourly) | 40 | 9 | 40 |
| Y | Sunday july 10, 2016 | c | Not Overhead | 13 | Non - Exempt (Hourly) | 40 | 9 | 40 |
| Y | Sunday july 17, 2016 | a | Not Overhead | 18 | Non - Exempt (Hourly) | 54 | 23 | 54 |
| Y | Sunday july 17, 2016 | overhead | Overhead | 9 | Non - Exempt (Hourly) | 54 | 23 | 54 |
| Y | Sunday july 17, 2016 | b | Not Overhead | 0 | Non - Exempt (Hourly) | 54 | 23 | 54 |
| Y | Sunday july 17, 2016 | c | Not Overhead | 13 | Non - Exempt (Hourly) | 54 | 23 | 54 |
| Y | Sunday july 17, 2016 | overhead | Overhead | 14 | Non - Exempt (Hourly) | 54 | 23 | 54 |
jahida
Impactful Individual
Impactful IndividualTry
Column = CALCULATE(SUM(Table[hours worked]), ALLEXCEPT(Table, Table[Employee], Table[start of week date]))
EDIT: I'm a bit confused, do you want a measure or a column?