A circular dependency was detected

[Anonymous]

 I  have a one table this table contains two factory details. i am trying to split seperate value for each factory using dax functions 

Factory                        AvgCtw                

PL                                 50

PL                                 65

PL                                 34

PL                                 11

PL                                 56

MX                                77

MX                                43

MX                                 22

MX                                 12

MX                                65

i want each factory total value . i have   new column applied formula 

AVG CTW - PL =

CALCULATE(SUM(Sheet1[Avg CTW]),Sheet1[Factory]="PL ") 

this formual is working without any error . 

this formual is working without any error . 

 When i create second formula  getting  

AVG CTW - MX =

CALCULATE(SUM(Sheet1[Avg CTW]),Sheet1[Factory]="MX ")  

A circular dependency was detected: Sheet1[Column], Sheet1[AVG CTW - PL], Sheet1[Column].

Any idea to resolve this Error 

this formual is working without any error . 

[amitchandak]

@Anonymous , You should create a second column like

AVG CTW - PL =
CALCULATE(SUM(Sheet1[Avg CTW]),Sheet1[Factory]="MX")