Forum Discussion
circular dependency --help please
Hi Anonymous
1. copy "dimension" and paste, then i get "dimension2" table,
in this table with only one column, "remove rows"->remove duplicates
2. copy "data" and paste, then i get "data2" table,
in this table, click on the [index] column and select "Remove other columns", then Removed Duplicates
3.in "dimension2" table, add a custome column
Then expand this column
Best Regards
Maggie
What does your overall table structure look like? Do you have many bi-directional relationships? Bi-directional 1 to many relationships are often the easy way to fall prey to this issue. The other cause could be if you have created a loop within your actual structure, whereby you might have to make a relationship inactive and make use of USERELATIONSHIP in dax if there is a special case.
HI Anonymous
i dont have any tables other than 3 .Ataching the screenshot . Do you mean that table which i am creating by the use of cross join is causing the issue ?
I notice the Cardinality and Filter direction are blank. Those options shouldn't be blank, and it shouldn't even let you select blank. Something is very broken here.
Are you able to select cardinality?
hi Anonymous : I am able to select them but "ok" button is not active state .can you try this sample data from your end once and let me know if any issues at my end.
It just occured to me what is wrong. Your building your bridging table in DAX, then trying to join that table into one of its parent tables. Thats creating the circular dependancy.
Instead, build this table inside the Edit Query section. Do this by right clicking on your query for the table you desire, click on "Reference", remove the columns you don't need and select "Remove Duplicates" in the next step. You should be able to create your join after you close and apply (you will first need to remove your Dax created table)