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

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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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 ?

     

    • 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.