Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |