Count and Average in power bi


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"))

Leave a comment