Forum Discussion
analyticspbi87
Helper I
Helper ICircular 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...
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.
analyticspbi87Helper I
Helper IThank you so much! All the new measures really help me out and it definitely means I have lots to learn.