Relationship Between Two Tables Calculation

[moses07_ferns]

I have a common column to connect two tables but when I filter by branch , flag & type it gives me the total of target. How do I solve this? I need the ID column only to connect the data. 

Table 2

Table 1

[mark_endicott]

@moses07_ferns - Just create a physical relationship between the two tables, using the ID column. 

This article has lots of guidance on relationships in Power BI: https://triangle.im/power-bi-mistake-7-why-bi-directional-relationship-issues-will-cause-headaches/#... and here: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships