Forum Discussion
Calculate Two Columns - Subtracting
Need a bit of help this morning on a calculated column I'm working on. I'm recieving the error message A Circular Dependency was detected
Column A first calculated revenue with the forumula below.
Computed Rev = ('Revenue'[clientBillRate]*'Revenue'[October Billable Hours])Column B is then calculated for costs using the formula below
Computed Costs = CALCULATE(SUMX('Revenue', 'Revenue'[October Billable Hours]*' Revenue'[payRate]))*1+'Revenue'[Cost Burden]
Finally to find the Spread I attempt to use
GM Spread = Computer Rev - Computed CostsWhere I then recieve the A Circular Dependency was detected error. What am I missing here. I know it's something simple I've overlooked for these calculations.
Thanks!
Your Computed Costs measure looks odd to me. Can you simplify it to this?
Computed Costs = ( 'Revenue'[October Billable Hours] * ' Revenue'[payRate] ) + 'Revenue'[Cost Burden]
6 Replies
LyonsBI_BRL ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
Hey amitchandak,
Yes I can provide some sample data here
Cost Burden IDclient BillRate payRate Computed Rev Computed Costs
0.3826 2972 $59.00 $30.00 $9,912 $5,040.38 0.0225 4433 $100.00 $50.00 $16,800 $8,400.02 0.2172 4534 $95.00 $60.00 $15,960 $10,080.22 0.3266 4774 $85.00 $50.00 $14,280 $8,400.33 0.1958 7281 $85.00 $50.00 $14,280 $8,400.20 0.3855 7340 $62.00 $34.00 $10,416 $5,712.39 0.2513 10006 $120.00 $68.00 $20,160 $11,424.25 0.2563 11005 $113.00 $68.00 $18,984 $11,424.26 0.2933 11297 $125.00 $77.00 $21,000 $12,936.29 0.2696 11802 $90.00 $53.01 $15,120 $8,905.95 0.3713 12687 $83.00 $45.00 $13,944 $7,560.37 0.2427 14270 $90.00 $55.00 $15,120 $9,240.24 0.2582 15679 $175.00 $115.38 $29,400 $19,384.10 0.2627 15853 $95.00 $60.13 $15,960 $10,102.10 0.3015 16776 $76.98 $46.00 $12,932.64 $7,728.30
Your Computed Costs measure looks odd to me. Can you simplify it to this?
Computed Costs = ( 'Revenue'[October Billable Hours] * ' Revenue'[payRate] ) + 'Revenue'[Cost Burden]Yep that worked, by simplifying it. that gives me the same output for the Computed Costs
Great. If you use that simplification instead, I don't think you'll get the circular reference error.
