Forum Discussion

Nikolas_ZN's avatar
Nikolas_ZN
Frequent Visitor
2 years ago

Circular_dependency between Calculated Measure and Column

Hi Team,

 

I have created two tables ( one main and one secondary) that are connected only via the Calendar Table Date column. In the secondary table I have created a measure. I want to use this measure inside a calculated column in the main table as a condition but I receive the following circular dependency error. I already have used the ALLEXCEPT() to remove the column indicated in the error message, but still the problem persists. Thanks for the assistance!!

 

3 Replies

  • samratpbi's avatar
    samratpbi
    Super User
    2 years ago

    Hi, Can you please share the relationship details? Usually from a calendar table to fact table, it will have one-many and most importantly a single directional relationship. Can you please try to update the relationships accordingly.

     

    Hope this helps.

    If this help to resolve your problem then please mark it as solution, Thanks!

  • Nikolas_ZN's avatar
    Nikolas_ZN
    Frequent Visitor
    2 years ago

    Please also note that when I am trying to change the relationship between the secondary and the primary I also have circular dependency, not allowing me the filter in both directions