Annual Average based on Distinct Count

Hi-Power BI community,

I need your help. I am trying to look at the average number of people I had for 2019. So far, I was able to get the Distinct Count of their ID by day. When I compare the Averagex vs just doing a distinct count I get the same answer. I have also tried creating a summary table and used just the Date, State of Employment and ID but that gives me different daily numbers. I know I missing something in my measure but I'm not sure what it is.

Thanks in advanced

(Measure) Avg Headcount = averagex(TABLE, DISTINCTCOUNT(TABLE [ID])).

Calc Table = SUMMARIZE(TABLE, Dates[Date], Employee [State],

"Distinct", DISTINCTCOUNT(TABLE [ID]))

Desired Results

Data Sample

DateHeadcount