Forum Discussion
Solved
Need help creating a Measure with AverageIf function
I have 'Roster' with employee data. I have it reported weekly but also have 'Roster' [Month] so I can group by month. I need the average count of FT employees by month. I got the first part of th...
I was able to solve my own question. Figured I would post in case in benefits anyone else:
Avg FT Employees =CALCULATE( COUNTA('Rosters'[WorkerType]),'Rosters'[WorkerType] IN { "FTE" }) /DIVIDE(SUM('Rosters'[WeekCountbyMonth]),COUNTA(Rosters[WeekCountbyMonth]))
I was able to solve my own question. Figured I would post in case in benefits anyone else:
Avg FT Employees =
CALCULATE( COUNTA('Rosters'[WorkerType]),'Rosters'[WorkerType] IN { "FTE" }) /
DIVIDE(SUM('Rosters'[WeekCountbyMonth]),COUNTA(Rosters[WeekCountbyMonth]))