Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

A circular dependency was detected

  • 1.  A circular dependency was detected

    Posted 24 days ago
    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 

    Makhdoom Liaqat