Forum Discussion
Anonymous
3 years agoNot applicable
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-Reporti...
amitchandak
3 years agoSuper 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])) )
Anonymous
3 years agoNot applicable
Is it a new column on headcount?