SQL to DAX Measure

I am planning to create DAX calculated measure in the PowerBI where Date will be passed as a slicer for the measure and it should return the current headcount of the employee.  SELECT  COUNT(DI...