A circular dependency was detected

[makhdoomliaqat]

Hi,

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

GName	Year	Opening Stock	InQty	initemvaluee	Average Value	Closing Stock Value	Opening Stock Value
Bahria Town	2020		4,454	126,610,300	28,426	24,673,943	-
Bahria Town	2021	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 

[V-lianl-msft]

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

[makhdoomliaqat]

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 

[V-lianl-msft]

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

[PaulDBrown]

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

[makhdoomliaqat]

i used your formula 

getting same error

[hnguy71]

Try this instead:

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

[makhdoomliaqat]

I have tried your formula but it give same error