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!