Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

  • 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's avatar
      Anonymous
      Not applicable

      Is it a new column on headcount?

    • Anonymous's avatar
      Anonymous
      Not applicable

      It only shows 5959 what is that?