Forum Discussion

Priyanka_28's avatar
Priyanka_28
New Member
1 year ago

Cicular dependency error

 I created column with below dax and I have used the new created column for creating another one calculation it showing circular dependency.help to resolve this,I used remove filter and all except.not working

4 Replies

  • Thennarasu_R's avatar
    Thennarasu_R
    Responsive Resident

    Hi Priyanka_28 

    While creating calculated sometimes circular dependency will appear reason you reffer calculated column. Use allexcept function It will rectify

    Return
    Calculate (a,Allexcept,Item Code Column)
    or
    Give the which column name should filter measure

    Thanks,
    Thennarasu R

    If answered your questions Accpeted a solution or Give kudos !


  • Priyanka_28 , Remove removefilter from the first column. and make sure the second one is created in the same table where the first one was created

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Priyanka_28 

     

    Has your problem been resolved? If so, could you mark the corresponding reply as the solution so that others with similar issues can benefit from it?

     

     

     


    Best Regards,

    Jayleny