cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Niels_NL Regular Visitor
Regular Visitor

Circular dependency detected

Hey guys,

 

Here's the situation:

  • Customer table (customerID, revenue2014, revenue2015, revenue2016, revenueTotal)
  • CustomerBase table (customerID, customerName, etc.)
  • Revenue table 2014 (customerID, ordertotal, etc.)
  • Revenue table 2015 (customerID, ordertotal, etc.)
  • Revenue table 2016 (customerID, ordertotal, etc.)

Relations are as followed:

  • Revenue tables > Customer table (linked on customerID)
  • Customer table > CustomerBase table (linked on customerID)

In the 'Customer' table I used some DAX measures to calculate the total revenue for each year and put them in the designated columns. Example of such a DAX measure:

revenue2014 = CALCULATE(SUM(tbl_revenue2014[ordertotal]);tbl_CustomerBase[customerID])

After doing this for each year, I created a DAX measure to sum 2014, 2015 and 2016 into a 'revenueTotal'. This one is as follows:

revenueTotal = CALCULATE(SUM(tbl_Customer[revenue2014])+SUM(tbl_Customer[revenue2015])+SUM(tbl_Customer[revenue2016]);tbl_Customer[customerID])

 

Now, after this, I'd like to create a new column containing a % of share in revenue for each customer. So "( total revenue generated by customer / total revenue of all ) * 100%".

I tried this DAX measure:

%_Share = tbl_Customer[revenueTotal]/SUM(tbl_Customer[revenueTotal])

But this gives me the error (translated from Dutch in English): 

" There is a circular dependency detected: tbl_Customer[revenueTotal], tbl_Customer[%_Share], tbl_Customer[revenueTotal] "

 

I can't seem to find what this error exactly means and how I can solve it or create a workaround. Anyone has any thoughts?

 

Thanks,

Niels

3 REPLIES 3
Highlighted
Microsoft Eric_Zhang
Microsoft

Re: Circular dependency detected

Hi Niels_NL,

Change the DAX expression of revenueTotal a little bit and your %_Share expression would work.

revenueTotal = CALCULATE(SUM(tbl_Customer[revenue2014])+SUM(tbl_Customer[revenue2015])+SUM(tbl_Customer[revenue2016]),tbl_CustomerBase[customerID])



Regarding the circular depency, check Understanding Circular Dependencies in Tabular and PowerPivot.

Rsmith Frequent Visitor
Frequent Visitor

Re: Circular dependency detected

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 Frequent Visitor
Frequent Visitor

Re: Circular dependency detected

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!

 

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors