Forum Discussion

makhdoomliaqat's avatar
makhdoomliaqat
Frequent Visitor
4 years ago

A circular dependency was detected

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  ...
Need Help
hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
4 years ago

Try this instead:

 

AvgValue = 
VAR _a = [ initemvaluee ] + [ Opening Stock ]
VAR _b = [ InQty ]+[ Opening Stock ]
RETURN
DIVIDE(_a, _b)
  • makhdoomliaqat's avatar
    makhdoomliaqat
    Frequent Visitor
    4 years ago

    I have tried your formula but it give same error