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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.