Forum Discussion
Trouble with circular type relationship
Remove the Bi-directional filters between Employee Roster and the two fact tables (Production and Leads). I'm guessing you're getting some unexpected cross-filtering, especially since you're using USERELATIONSHIP() to filter on a different date column.
Hi wfarrell,
I would suggest you change the "Cross filter direction" to Single and activate the relationship between Date and Leads. Can you share a sample file, please? Maybe we can help more. Please mask the sensitive parts first.
Best Regards,
Dale
Hi Chris,
Thank you for the timely response. I'm still running into issues when I add the number of leads to the matrix. I'm unable to filter by the date[date] column. All I get is the total number of leads per employee, but I cannot filter it by date[date]. I think the issue is beacuse of the relationships between Leads[Employee] <----- Employee Roster[Employee] and the relationship between Leads[LeadDate] <----- Date[Date]. I'm only picking up the relationship between Leads[Employee] <----- Employee Roster[Employee].
Let me know if I should try to clarify this better.
- William
To further clarify, I am trying to calculate the number of leads from the leads table based on two seperate lookup tables, which are Date and Employee Roster. It only seems to work with the Employee Roster lookup table, but not the Date lookup table.
- William