Circular dependency, creating a new content with a data from a calculated column.

[Syndicate_Admin]

Nice day

I have a table of a production process, in this table are the different production lines with their associated production diaría by item

another table with the target production defined for that month:

I need to bring in the daily production table the objective production data for that month by production line and after this calculate in another column the difference between real production and target production, using a lookupvalue I could obtain the target production but when I try to create the other column with the difference between real and objective I get an error of circular dependencies, I do not know how to solve this since in an excel using buscarv does not generate these errors because it is not related. I appreciate any help you can give me.

[lbendlin]

Please provide sample data in a usable form.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.