Forum Discussion
Solved
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...
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]
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
