Forum Discussion

EaglesTony's avatar
EaglesTony
Post Prodigy
1 year ago
Solved

How 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...
Need Help
  • EaglesTony's avatar
    EaglesTony
    1 year ago

    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"

EaglesTony's avatar
EaglesTony
Post Prodigy
1 year ago

I will try it and if it works, will post the solution here for others.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, EaglesTony 
Thank you for your swift response. I look forward to your updates and hope that our assistance proves effective for you.

 

Additionally, if you find our help beneficial, I would greatly appreciate it if you could accept saud968's response as the solution. This would significantly contribute to the growth of our community.

 

Thank you in advance for your consideration. Wishing you a wonderful day ahead!

 
Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu