cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
makhdoomliaqat
Frequent Visitor

A circular dependency was detected

Hi,

i am new on powerbi. i am getting this error. Here is below my table.

GNameYear Opening Stock  InQty  initemvaluee  Average Value  Closing Stock Value  Opening Stock Value 
Bahria Town2020        4,454        126,610,300             28,426               24,673,943                                  -  
Bahria Town2021                   868       6,379        166,903,972             23,031               16,121,537                                  -  

 

 

I am taking average from below dax

 

Average Value = (([initemvaluee]+[Opening Stock Value])/([inqtyy]+[Opening Stock]))

 

 

i want the closing stock value previous year in the field of opening stock value. but it gives me error of 

 

 

A circular dependency was detected

 

Please help how it will 

 

 

7 REPLIES 7
V-lianl-msft
Community Support
Community Support

Do you call measure when you create a calculated column?Maybe you could consider creating a measure or re creating the corresponding calculated column from the previous measure

i have tried all but all in vain if you want the file i am attaching.
https://www.mediafire.com/file/pmb7u1thsag1kq1/Cost_of_goods_sold.pbix/file 

I checked the file you provided and found no errors. Has the problem been solved?

PaulDBrown
Super User
Super User

This video from the gurus at SQLBI will probably prove useful:





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






makhdoomliaqat
Frequent Visitor

i used your formula 

makhdoomliaqat_0-1632529417710.png

 

 

getting same error

 

makhdoomliaqat_1-1632529475321.png

 

hnguy71
Solution Supplier
Solution Supplier

Try this instead:

 

AvgValue = 
VAR _a = [ initemvaluee ] + [ Opening Stock ]
VAR _b = [ InQty ]+[ Opening Stock ]
RETURN
DIVIDE(_a, _b)

I have tried your formula but it give same error

makhdoomliaqat_0-1632530137877.png

 

 

makhdoomliaqat_1-1632530168287.png

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!