Measure to return value from a connected table based on another table selection

Table 1 (LFSLTRNR) has monthly sales for an agent Table 2 (Agents Target) has monhtly target for an agent. Table 1 and 2 are connected via agent code   Report has Sale date filter from table1 and...