circular dependency --help please

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

You use 'dimension'[dim] to create the bridge table, then create the relationship between 'dimension' and "check" table, so it occurs an error for circular dependency.

More introduction about avoiding circular dependency please read this article.

 

As a workaround, you could create this bridge table in Edit Queries.

Create a blank query, then paste the following code in Advanced editor

let
    Source1 = dimension,
    #"Removed Duplicates" = Table.Distinct(Source1),
    Source2 = data,
    #"Removed Other Columns" = Table.SelectColumns(Source2,{"index"}),
    #"Removed Duplicates2" = Table.Distinct(#"Removed Other Columns"),
    addcolumn=Table.AddColumn(#"Removed Duplicates", "index", each #"Removed Duplicates2"),
    #"Expanded index" = Table.ExpandTableColumn(addcolumn, "index", {"index"}, {"index.index"})
in
    #"Expanded index"

 

Or you can edit the table steps by steps with the UI 

1.Query1:

copy and paste the 'dim' table->Removed Duplicates

2.Query2:

copy and paste the 'data' table->click on the [index] column and select "Remove other columns"->Removed Duplicates

3.in Query1:

Add column from Query2 , then expand the column

 

Best Regards

Maggie