Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

circular dependency --help please

hi   i am just trying to relate tables using bridge table . where i am facing the circlaur dependency .   dim: feedyard sex ration   data table : feedyard sex ration index alex bike 1200 0...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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)