DAX formula not working

[BrianJ]

@powerbideveloper,

Check out this post - it’s focused on identifying all workers < 40 hours week, but the DAX should be easily modifiable to fit your opposite situation.

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

@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] Full solution file posted below. I hope this is helpful. Brian eDNA Forum - Aggregate Hours Less Than 40.pbix (93.6 K…

• Brian