Forum Discussion

Niels_NL's avatar
Niels_NL
Advocate I
10 years ago

Circular dependency detected

Hey guys,   Here's the situation: Customer table (customerID, revenue2014, revenue2015, revenue2016, revenueTotal) CustomerBase table (customerID, customerName, etc.) Revenue table 2014 (custom...
Need Help
Rsmith's avatar
Rsmith
New Member
9 years ago

I am new to this and have just gotten a circular dependency error message:

 

A circular dependency was detected: 'TPID_DATA'[L1_Proactv_BaseRev],'TPID_DATA'[Calculated Column 1],'TPID_DATA'[Calculated Column 1],'TPID_DATA'[L1_Proactv_BaseRev],'TPID_DATA'[L1_Proactv_BaseRev].

 

The formula I wrote:

 

=CALCULATE(sum(TPID_DATA[L1_ProactiveBase_Rev]))

 

I am not sure why I am getting this error. Any sugguestions?  Thank you!

 

Rsmith's avatar
Rsmith
New Member
9 years ago

Sorry, please disregard. Evidently way too new... figured this one out... that said, I am still running into circular dependency issues for this model and would appreciate being directed to any documentation that is written for those of us who are not sql programmers  :).... anything written in something that is a little more basic or plain english....

 

thank you!