cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rachelbabcock
Helper I
Helper I

Circular Dependency Error

Hello,

 

I am having an issue with a Circular Dependency error. I unfortunately cannot share my dataset due to company policy, but am hoping I can explain enough here that someone might be able to help. If you need me to provide any additional info, send screenshots, etc., let me know.. I've been trying to figure this out for DAYS. 

 

Dataset is a merge of 2 different tables. The merge takes place at the Power Query level so everything is already in 1 table when it loads into desktop.

 

I'm simply trying to add 2 pieces of information together in a calculated column. One is a measure (Amt CF SPLIT), the other is a column (Distribution) from the original dataset. 

COLUMN = [Amt CF SPLIT] + Distribution. For some reason, I get an error that says: "Circular dependency was detected. Amt CF SPLIT, Column, Amt CF SPLIT."

 

I cannot figure out why this is happening and what I should do to fix this. I've read about 5 pages worth of posts and responses on circular dependencies and haven't found a solution.

 

For reference -- the measure in the column is the average of another column in the dataset. For some reason, if I try to do a column that averages that column, my values don't show up correctly. however, if i do a measure, it works. I've narrowed it down to the measure being the issue here; if I try to do the same thing with another random column instead of my measure, the error goes away. 

 

Any help would be MUCH appreciated!!!

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @rachelbabcock ,

 

you should never use a measure inside a calculation of a calculated column, here it is also responsible for the circular dependency as the measure tries to average rows whereas the calculated column just wants to resolve the row context (please be aware that this explanation is very simplified).

 

if you already spend days, spend some additional hours and create sample data, that allows understanding your requirement. From my understanding, you just need to create a single table, because everything happening in power query is not relevant to understand the problem. Make sure that you recreate the same calculated columns if any are existing. Just enter data, upload the pbix to onedrive or dropbox, and share the link.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

2 REPLIES 2
TomMartens
Super User
Super User

Hey @rachelbabcock ,

 

you should never use a measure inside a calculation of a calculated column, here it is also responsible for the circular dependency as the measure tries to average rows whereas the calculated column just wants to resolve the row context (please be aware that this explanation is very simplified).

 

if you already spend days, spend some additional hours and create sample data, that allows understanding your requirement. From my understanding, you just need to create a single table, because everything happening in power query is not relevant to understand the problem. Make sure that you recreate the same calculated columns if any are existing. Just enter data, upload the pbix to onedrive or dropbox, and share the link.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hey Tom,

 

I think I just needed to look at it with fresh eyes and fresh data. When I built a sample data set to post here, the process actually worked fine. I went back into my original dataset and initially just started from scratch. Not quite sure what was wrong before but just glad to have it working. Thanks!

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors