Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Circular Dependency Was detected possible bug.

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. 

 

 

 

Need Help

3 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    2 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    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