Min and Max of Headcount for Date Range

[Anonymous]

HI I have a table of Employee ID and Pay Date.

I count the distinct employee IDs for a date range: 

HeadCount = DISTINCTCOUNT(Paycom[Employee_Code])

I want to show the minimum maximum and average of Distinct Employee Headcount  for any unique PayDate in my filtered date range.

Thanks in Adnace

[Greg_Deckler · Accepted solution]

@Anonymous Maybe:

Measure Max =
  VAR __Dates = ADDCOLUMNS('Dates'[Date],"__HeadCount",[HeadCount])
RETURN
  MAXX(__Dates,[__HeadCount])

Measure Min =
  VAR __Dates = ADDCOLUMNS('Dates'[Date],"__HeadCount",[HeadCount])
RETURN
  MINX(__Dates,[__HeadCount])

Measure Average =
  VAR __Dates = ADDCOLUMNS('Dates'[Date],"__HeadCount",[HeadCount])
RETURN
  AVERAGEX(__Dates,[__HeadCount])