How to fix CIRCULAR DEPENDENCIES, I have to implement this Data model Design so I can not change it

[TungNguyen_19]

Hello our community,

I'm facing the circular dependencies. Yes I have read what is it and many post about this annoying problem but I can not find any solution in my case because I can not change the data model design. Please have a look of my diagram

I have two calculation column:

RefCost_EXP = CALCULATE(VALUES('M Cost Volume'[Avg Total Cost]), USERELATIONSHIP('(EXP) 3 LOAD FULL'[ID_Cost], 'M Cost Volume'[ID])) 

RefRevenue_EXP = CALCULATE(VALUES('PBI_VN_CS_recap_CSal'[Total Revenue (EXed Rate)]), USERELATIONSHIP('(EXP) 3 LOAD FULL'[ID_REVENUE], 'PBI_VN_CS_recap_CSal'[ID])) 

And I want to calculate the Margin:

Margin = [RefRevenue_EXP] - [RefCost_EXP] 

Well as you guess the error appear

I have to connect 2 Red Table (in the picture) to the Calendar Dimension. Also note that red table is the Calculated Table:

I stuck on this all day and try many ways but I have no idea to fix this. Please help me, many thanks to you guys ❤️

[TungNguyen_19]

Hi @johnt75 Thank you so much! You save my day

[johnt75 · Accepted solution]

Inside the CALCULATE for each column you need to add ALLEXCEPT on the column, or columns, which uniquely identify a row in the load full table.