How to link target table and sales table using Bridge ?

Hi, admin11 

According to your requirement, I modify your bridge table code, then you can put the bridge table field 'staff' in the table1's value.

Like this:

Group16 = 
// DISTINCT (
//     UNION (
//         SUMMARIZE ( SALES,  SALES[Sales Staff] ),
//         SUMMARIZE ( TARGET_16, Target_16[GROUP_16])
//     )
// )
INTERSECT(DISTINCT(SALES[Sales Staff]),DISTINCT(Target_16[GROUP_16]))

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.