Forum Discussion
Solved
Circular Dependency Issue on measures
I am looking for some help on a recent issue we are running into regarding a circular dependency. Any guidance on a simple way around this would be great. In the table below, each column is a specifi...
The way around this circular dependency error for me was to just go a different route and keep a rolling total of the activity each period. It seems to be working for my requirements. Not a direct way to solve the circular dependency, but it was a good solution around it.
Measures:
Rolling Total = [New] + [Modifications] + [Refinement]
Ending = [Rolling Total] - [Awarded]
The way around this circular dependency error for me was to just go a different route and keep a rolling total of the activity each period. It seems to be working for my requirements. Not a direct way to solve the circular dependency, but it was a good solution around it.
Measures:
Rolling Total = [New] + [Modifications] + [Refinement]
Ending = [Rolling Total] - [Awarded]