Calculated columns with columns from different tables

Hi Ley , 

There is a good description for circular dependencies: https://www.sqlbi.com/articles/understanding-circular-dependencies/.

It does not allow to have two calculated columns that contain measures that are also based on that table.   As a workaround, you may try to convert these into measures instead of column.

You can refer to the similar case: "A circular Dependency was detected" error while creating a calculated column.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.