A circular dependency was detected while creating two calculated column

[Anonymous]

Getting Circuar dependency error as show in screenshot

this what the requirement to calculate focus and non focus categories based on the conditions.
I am using only one table in the enitre report.
I am using Swicth() as a dax function.

Not able to create this as a measure because some dimension columns are used to compare and map focus and non focus category.

Note - Selection Fiscal&Period, FY21 Vs FY22,CTD act Vs CTD ODE,FY22 POV CCI% are calcualted measures

Focus Accounts Category_Cal Column = SWITCH(TRUE(),

(FA_Analysis_Data[Contract] = "#"),"Non Focus",

(FA_Analysis_Data[EAC_Rev] = 0 || FA_Analysis_Data[EAC_Rev]= BLANK()), "Non Focus",

(FA_Analysis_Data[Valid_from]> FA_Analysis_Data[Selection Fiscal&Period]),"Non Focus",

(FA_Analysis_Data[EAC_Rev]<1), "Non Focus",

(FA_Analysis_Data[Valid_To]<=FA_Analysis_Data[Selection Fiscal&Period]),"Non Focus",

(FA_Analysis_Data[Valid_from]> FA_Analysis_Data[Selection Fiscal&Period]),"Non Focus",

(FA_Analysis_Data[Valid_To]<=FA_Analysis_Data[Selection Fiscal&Period]),"Non Focus",

FA_Analysis_Data[FY21 Vs FY22]<0 &&([FY22 POV CCI%]>=0.3),"Non Focus",

FA_Analysis_Data[CTD act Vs CTD ODE]>0 && [FY21 Vs FY22]>0 && [FY22 POV CCI%]>0.3,"Non Focus",

FA_Analysis_Data[CTD act Vs CTD ODE]<0 &&[FY21 Vs FY22]>0 && [FY22 POV CCI%]>0.3,"Non Focus",

"Focus")

Any sugegstions how to resolve this error ?

[Anonymous · Accepted solution]

Yes,there are 2 calculated columns(A and B) which are created with  measures and calculated columns.

now the requirement is, from A and B need to create another calculated columns C and D.
calculated columns A and B are working fine but not able to create C and D.

So, when i am trying to create C and D i am getting Circular Dependency error.

Please suggest solution for this.

[amitchandak]

@Anonymous , if measures are used with the hope that calculated columns will use slicer value, then they will not. So best is to reconsider those calculations to use columns.  and then create a new column on top of those columns

[amitchandak]

@Anonymous , Can you a sample pbix after removing sensitive data.

One of the column used here is using this column or something like that

or these are measures [FY22 POV CCI%] , you can not use measure in a column

refer

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/