Aggregate hours per week per employee then show weeks where total < 40

Power BI
3

@ferdsjoseph,

Here’s one way to do this using three branched measures:

Total Hours = SUM( 'Hours Worked'[Hours Worked] )

Total Hrs Employee by Week = 
CALCULATE( [Total Hours],
    VALUES( Employees[Name] ),
    VALUES( Dates[Week Number] )
)

Total Hrs Employee by Week < 40 = 
IF( [Total Hrs Employee by Week] < 40,
    [Total Hrs Employee by Week],
    BLANK()
)

image
image.png1086×490 40.3 KB

Full solution file posted below. I hope this is helpful.

  • Brian

eDNA Forum - Aggregate Hours Less Than 40.pbix (93.6 KB)

2 Likes