topic Re: Circular_dependency between Calculated Measure and Column in DAX Commands and Tips

Circular_dependency between Calculated Measure and Column

Nikolas_ZN — Sun, 28 Apr 2024 09:22:24 GMT

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!!

Re: Circular_dependency between Calculated Measure and Column

samratpbi — Sun, 28 Apr 2024 11:05:29 GMT

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!

Re: Circular_dependency between Calculated Measure and Column

Nikolas_ZN — Sun, 28 Apr 2024 15:07:59 GMT

Hi,

Thanks for reaching out.

Re: Circular_dependency between Calculated Measure and Column

Nikolas_ZN — Sun, 28 Apr 2024 15:10:20 GMT

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