Forum Discussion
Unable to solve circular dependency
My issue regards a circular dependency I am not able to understand. Here's my relationship pattern: In table Margine I built 2 calculated columns which I copy down here: CNTMR...
Anonymous,
This happens when you have context transition happens in your calculated column, and your table that contains the calculated column does not have a primary key. You can look at this article to have a better understanding of circular dependency.
Anonymous,
Since you have context transition (using CALCULATE) in the two calculated columns of the many side of the relationship, calculated column 1 depends on all the columns in the Margin table + calculated column 2. Same thing happens to calculated column, where it depends on all the columns in the Margin + calculated column 1. This leads to circular dependency that explains in the article.