Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ❤️
Solved! Go to 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.
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.
User | Count |
---|---|
106 | |
89 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |