Forum Discussion
Stuznet
7 years agoHelper V
A circular dependency was detected Calculated Column
Hi guys, I'm trying to create a Venn diagram and ran into a circular dependency issue. I need to create two calculated column category one for Binary Start and the other Binary Actual Start. ...
v-juanli-msft
7 years agoCommunity Support
Hi Stuznet
As learned from the blog, the Venn diagram chart may not fit your scenario.
Could you describe your requirement with words so i can find a workaround for you?
In addition, understand the circular dependency error from the article
https://www.sqlbi.com/articles/understanding-circular-dependencies/
In your case, Power BI does not allow to have two calculated columns that contain measures that are also based on that table. In order to understand why, you'd need a better understanding of what's going on under the hood.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.