How to filter data from two unrelated tables

[Othman]

Hello,

I have two tables with different rows and columns. But two columns are similar. "Period, and Product".

I made a "line and clustered column chart", that has "Period" in the x-axis.

One the y-axis, it has two data columns from two tables "Total CBB, and total ECL"

Now, I want to add a line in the chart the is the difference between the two columns in the Y-axis "Total CBB, and total ECL".

Can you please assist? Let me know if I can clarify more. I want to be able to filter the chart by "Period" and "Product"

The Second Table:

[lbendlin]

You can use TREATAS  to transfer filters from one table to another.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
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.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523