Forum Discussion

TungNguyen_19's avatar
TungNguyen_19
Icon for Helper III rankHelper III
3 years ago
Solved

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

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 ❤️

  • 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.

2 Replies

  • 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.