Calculate Over Time Weekly Average by different categories

[lc1]

Hello,

I have an Over Time report by pay period and I'd like to create a matrix that indicates:

- Total number of employees working OT

- Average number of employees working less than 5 OT hours per week

- Average number of employees working 5-10 OT hours per week

- Average number of employees working over 10 OT hours per week

 Thank you

[Anonymous]

hello i would create the following measures 

- Total number of employees working OT

employees working OT = calculate(distinctcount(employee) ,filter(payperiodtable, OT Hours >= 0))

- Average number of employees working less than 5 OT hours per week

Average less then 5 OT hours = [employees working OT] / (calculate(distinctcount(employee) ,filter(payperiodtable, OT Hours <= 5))

- Average number of employees working 5-10 OT hours per week
Average btwn 5 - 10 OT hours = [employees working OT] / (calculate(distinctcount(employee) ,filter(payperiodtable, OT Hours > 5 && OT hours <=10 ))

- Average number of employees working over 10 OT hours per week

Average greater then 10 OT hours = [employees working OT] / (calculate(distinctcount(employee) ,filter(payperiodtable, OT Hours > 10))