Circular Dependency Was detected possible bug.

[eliabreupr]

Hi I have searched everywhere and I have tried everything still not working. The error doesn't specify to which column is occuring the dependecy. It showing that dependecy is with the Calculated column that I'm trying to created. Blue means table 1 and Pink Table 2. I have tried all except , removing the filters, adding. nothing works and i'm pretty sure there is not dependecy. Is this a bug or something is missing in the DAX? We have a tabular model. First time we have this issue. 

[Anonymous]

Hi @eliabreupr ,

Check out these two blogs:
Understanding circular dependencies in DAX - SQLBI
Avoiding circular dependency errors in DAX - SQLBI

Try replacing some of these functions to avoid nulls in the relation.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[Ritaf1983]

Hi @eliabreupr 
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.

[eliabreupr]

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