Forum Discussion
Circular Dependency Was detected possible bug.
Hi Anonymous
This is very challenging to answer these types of questions without access to the model.
Highly recommend preparing a small dummy pbix with the needed logic and sharing the link.
Our model is a tabular Star/Snowflake hybrid. It is not possible to create a dummy because it is large. The blue table is the Fact table, and the pink one is a dimension. If you notice, all the calculated table is based on the columns of the Fact table. The only other calculated column is "Collision Deductible," which is a switch statement that doesn't refer to any measure, calculated table, or show an error.
I conducted more tests before this post by changing the "Collision Deductible" with a non-calculated column, and the issue still persists. She added the "ALL" filter using the dimension because that is where the calculated column is created due to data relations. However, no matter where I create the calculated column, it keeps showing the same error. It doesn't seem to have any dependencies with other columns; it appears to be an isolated issue. The relationship between the two tables is a Fact table many-to-one Dimesion , with the dimension filtering the Fact table." I hope this helps