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
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 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