Relationship issues

Hello,

I have the following table (Left) which contains two columns Material and Batch#, the column "Qty" is coming from the same table as the batch # and "Sum Unrestricted" is coming from a different table, the goal is to compare the qty available at batch level but the column "Sum Unrestricted" is showing the result for the material not for the specific lot that I need. As you can see on the right table, the sum of all the lots is 10820 but the correct total should be 1320. How can I get the result for the lot# only showing on the right table?

Thanks!!!!