Circular dependancy error (creating relationship)

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