Forum Discussion

analyticspbi87's avatar
analyticspbi87
Icon for Helper I rankHelper I
1 year ago
Solved

Circular dependency questions with measures

Currently having an issue where 2 measures are creating a circular dependency.   I have a feeling it's because one of the calculations invole a filter. I tried using both measures (where te circula...
Need Help
  • parry2k's avatar
    parry2k
    1 year ago

    analyticspbi87 hey I took data from dropbox and created measures to break down the calculation and it seems to be working. Not sure why you are getting dependency error, maybe in your model you have more tables/calculated columns that is leading to the error.

     

    See attached. It is always recommended to add seperate measure for complex calculations or use variable so that it is easy to debug.

    Here is the output that in-align with excel sheet you provided.

     

     

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
1 year ago

analyticspbi87 hey I took data from dropbox and created measures to break down the calculation and it seems to be working. Not sure why you are getting dependency error, maybe in your model you have more tables/calculated columns that is leading to the error.

 

See attached. It is always recommended to add seperate measure for complex calculations or use variable so that it is easy to debug.

Here is the output that in-align with excel sheet you provided.