Forum Discussion
RanjanThammaiah
Helper V
Helper VA circular Dependency was detected
Hi,
Could some one help me to resolve this issue.
i have created one calculated column and if try with another calculated column i was getting this error.
I don't wanted to create the measure because i would be creaing one more measure using these columns.
The error is showing on the formulaCalculated with no error
1 Reply
v-lili6-msftCommunity Support
hi, RanjanThammaiah
This is a good refresher on circular dependencies:
Understanding Circular Dependencies in Tabular and PowerPivot
Since you don't want to create the measure, try these formulae
Growth% = DIVIDE('Cross Domain'[MTD_TER]-'Cross Domain'[PMTD_TER],SUM('Cross Domain'[PMTD_TER]),0)Rev Plan Gr% = DIVIDE('Cross Domain'[Revebue_Plan]-'Cross Domain'[PFY_TER],SUM('Cross Domain'[PFY_TER]),0)Best Regards,
Lin