Forum Discussion
EaglesTony
Post Prodigy
Post ProdigyHow to fix Circular reference in Data Relationship
Hi, I have a slicer that uses a column(Sprint) in a table(SprintDates). I have table1 that I calculated a column(Sprint) that works. I then(via a lookupValue) created a new column(S...
All I figured this out, it had to do with setting up the relationships as Single instead of Both, which caused the amiguous error.
Basically, I have a top table called Team, I connected this as a single connection to the "child tables" based off a key (some of the fields in the child tables were also used in slicers) and this fixed the issue, so have to be careful with "both"
saud968
Memorable Member
Memorable MemberYou can try it if it helps then good, otherwise we have other expert can review this further.
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!
EaglesTonyPost Prodigy
Post ProdigyI will try it and if it works, will post the solution here for others.