Circular dependency was detected on calculated column in source table

[Anonymous]

Dear All,

I have my source which is a semantic model from the existing workspace. The source for this model is SQL server. I don't know if this is important, but I would like to present you the background.

I tried to add to one of my tables (Person) one new column based on CALCULATE, but I got an error:

I was surprised to see that so I created a new table that is fully equal to Person (Table = Person). With this additional table, I don't get the circular dependency error when I'm adding a new column - no error was detected.

Column Id contains only unique values.

Could anyone advise on the reason why the expression works in one table and doesn't work in the other?

Thank you in advance!

[some_bih]

Hi @Anonymous 

No columns or model available to provide possible solution.

Check link and link2  to your possible scenario.