Calculate Two Columns - Subtracting

[LyonsBI_BRL]

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 Costs

Where 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! 

[AlexisOlson · Accepted solution]

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]

Yep that worked, by simplifying it. that gives me the same output for the Computed Costs

[AlexisOlson]

Great. If you use that simplification instead, I don't think you'll get the circular reference error.

[LyonsBI_BRL]

That did it thank you!

[amitchandak]

@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/

[LyonsBI_BRL]

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