Forum Discussion
Table Relationship
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!
3 Replies
- amitchandakSuper User
Anonymous , You can create a measure like this on headcount
calculate(Count(headcount[Enterprise ID]), filter(headcount, headcount[Date] in values('calendar Ref'[Date])) )
- AnonymousNot applicable
Is it a new column on headcount?
- AnonymousNot applicable
It only shows 5959 what is that?