Cicular dependency error

[Priyanka_28]

 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

 

[Anonymous]

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

[Thennarasu_R]

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 !

[amitchandak]

@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.

[Priyanka_28]

Am facing same issue.kindly help