count “Employee ID” group by “AsOfDate” (data ending month)
average “No Of Count Employee” and where condition employe status = ‘active’
CALCULATE(AVERAGEX(
SUMMARIZE(Emp_data
,Emp_data[AsOfDate]
,"COUNT"
,DISTINCTCOUNT(Emp_data[EmployeeID])
),[COUNT]
)
,FILTER(Emp_data,Emp_data[Status] = "Active"))