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 .
