Forum Discussion
Solved
Trouble with circular type relationship
Hello, I am running into an issue when using multiple relationships that appear to be in a circular pattern. I have four tables total, Production Table & Leads Table which are not unqiue, while ...
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
Hello, You could try merging the Leads Table with the Employee roster table in P.Query to bring the wanted field and avoid the relatioship issue.