Forum Discussion
Circular Dependency Error
Hi,
I have three tables:
A) clarity allocations
B) clarity available
C) cdl resources monthly
A and B are joined on "pmfkey" with C
I want to create:
a) a column in table C, which will bring the "Future Alloc Col" from table A and
b) a column in table C, which will bring the "FutureAvailable Col" from table B
I have done a) succuessfully using the following calculation
Future Allocations Column = CALCULATE(SUM('CLARITY ALLOCATIONS'[Future Alloc Col]),USERELATIONSHIP('CLARITY ALLOCATIONS'[PMFKEY],'cdl resources monthly'[PMF Key]))However, trying to use exactly the same logic in order to achieve b), fails
I have gone through the Circular Dependencies threads, which are not very easy to understand to be honest, but I have deleted numerous relationships among my tables in order to keep it as simple as possible and avoid this type of errors. Even if there is no t a solution, can somebody explain why I can bring the column from table A to table C and I can't do the same from table B to C?
It is vital to have all these columns in table C, because this tabel drives the visualizatio as it is the table with Unique pmfkeys on which I can create relationships to.
2 Replies
- Greg_DecklerCommunity Champion
Would need to see sample data and your formulas for your calculated columns in B, FutureAvailable Col.
Circular dependency errors are the worst.
- v-jiascu-msftMicrosoft Employee
Hi harrinho,
The relationships are active. So the userelationship seems unnecessary. Please try to remove it. If the issue persists, please share a dummy sample file as Greg_Deckler suggested.
Best Regards,
Dale