Count the number of times employees charged more than 40 per week by EndOfWeek

[Anonymous]

Hello Community,

I summarized regular hours recorded by the EndOfWeek, and I'm trying to count the number of times this has occurred for semi-monthly pay periods where more than 40 per week have been recorded and those hours need to be moved to overtime .  This is what I have so far:

Count of Hours Over 40 by Week =

VAR R_HoursOver40 =

IF (

CALCULATE (

SUM ( Timesheetlines[ENTERED_HRS] ),

Timesheetlines[Type] = "R",

ALLEXCEPT ( Timesheetlines, Timesheetlines[EndOfWeek] )

) > 40,

COUNT(Timesheetlines[EMPL_ID]),

0

)

RETURN

R_HoursOver40

Thanks in advance!

[amitchandak · Accepted solution]

@Anonymous ,

Hours >40

SUMX(filter(Summarize(Timesheetlines,Timesheetlines[EMPL_ID], Timesheetlines[EndOfWeek],"_1",SUM ( Timesheetlines[ENTERED_HRS] )),[_1]>40),[_1])

Occurance , where Hours >40

Countx(filter(Summarize(Timesheetlines,Timesheetlines[EMPL_ID], Timesheetlines[EndOfWeek],"_1",SUM ( Timesheetlines[ENTERED_HRS] )),[_1]>40),[EMPL_ID])

Employee Count, where Hours >40
Countx(summarize(filter(Summarize(Timesheetlines,Timesheetlines[EMPL_ID], Timesheetlines[EndOfWeek],"_1",SUM ( Timesheetlines[ENTERED_HRS] )),[_1]>40),[EMPL_ID]),[EMPL_ID])