A circular dependency was detected

Question

Hi,i am new on powerbi. i am getting this error. Here is below my table.GNameYear&nbsp;Opening Stock&nbsp;&nbsp;InQty&nbsp;&nbsp;initemvaluee&nbsp;&nbsp;Average Value&nbsp;&nbsp;Closing Stock Value&nbsp;&nbsp;Opening Stock Value&nbsp;Bahria Town2020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,454&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 126,610,300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28,426&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24,673,943&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;Bahria Town2021&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 868&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,379&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 166,903,972&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23,031&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16,121,537&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;I am taking average from below dax&nbsp;Average Value = (([initemvaluee]+[Opening Stock Value])/([inqtyy]+[Opening Stock]))&nbsp;&nbsp;i want the closing stock value previous year in the field of opening stock value. but it gives me error of&nbsp;&nbsp;&nbsp;A circular dependency was detected&nbsp;Please help how it will&nbsp;&nbsp;&nbsp;

hnguy71 · Answer

Try this instead:&nbsp;AvgValue = 
VAR _a = [ initemvaluee ] + [ Opening Stock ]
VAR _b = [ InQty ]+[ Opening Stock ]
RETURN
DIVIDE(_a, _b)

makhdoomliaqat · Answer

i used your formula&nbsp;&nbsp;&nbsp;getting same error&nbsp;&nbsp;

makhdoomliaqat · Answer

I have tried your formula but it give same error&nbsp;&nbsp;&nbsp;

pauldbrown · Answer

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

v-lianl-msft · Answer

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

Forum Discussion

A circular dependency was detected

7 Replies

Related content

A Circular Dependency was detected

Circular dependency

Error: A circular dependency was detected

A circular dependency was detected

A circular dependency was detected

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	-