Forum Discussion

Regular Visitor

7 years ago

Solved

Help Avoiding A Circular Dependency

Hi all, I am having an issue understanding how to get out of a circular dependency in 4 simple tables. Currently I get the error saying that I cant make a particular relationship active because it w...

Need Help

v-yuta-msft
7 years ago
sh856531 ,

About how to avoid circular dependency in power bi, I would suggest you to read article below:

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

sh856531

Regular Visitor

7 years ago

In case it helps you can see roughly what I'm after. The employee has various aggregate values calculated but at the moment they are not being managed by a common date. So the Reopen Rate column for example is showing the reopen rate for all time, not say the past 30/90/180 days.