Circular dependancy error (creating relationship)

[topkapi]

Hi All,

I have a custom table in my data model. I created antother column based on the condition in other column (which already on a formula based). I do not have any primary key for this table. This table doesn't come from any data source and created by me.

MemID = if('Table'[Type]="MID",'Table'[VALUES]).

I want to make relationship with my other table (from datasource) with it's field MSID, but I get circular reference error. How to solve this issue. Thanks

[v-chuncz-msft · Accepted solution]

@topkapi,

You may take a look at the following articles.

• https://www.sqlbi.com/articles/understanding-circular-dependencies/
• https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/