Table Relationship

[xRTP]

Hello im having trouble with the relationships on my tables. I have 3 tables, 1 main table and 1 headcount table for mapping and 1 calendar ref. So i connect Main Table to Calendar Ref (MDate-Reporting Date) and Main Table to Headcount Table (EID.email-EnterpriseID). I use the Calendar Ref (Month) for slicer but the result  on the Headcount Table it doesnt filter using the slicer. 

If i connect Calendar Ref to Headcount Table same issue, and if i connect calendar ref to headcount and main table no data will display. Do i need a new table? Thanks in advance!

[amitchandak]

@xRTP , You can create a measure like this on headcount

calculate(Count(headcount[Enterprise ID]), filter(headcount, headcount[Date] in values('calendar Ref'[Date])) )

[xRTP]

It only shows 5959 what is that?

[xRTP]

Is it a new column on headcount?