Target measure for three different variables

Hello Everyone,

I have a question regarding the target measure that takes into account 3 different variables at once.

Basically, I have 3 different tables - Sales transactions; Yearly targets for Products; Yearly targets for Customers.

Both target tables consist sales rep column as well.

and I would like to make 3 different charts that compare sales vs targets (products, customers, sales reps).

If I make a connection between sales transactions vs target tables, everything works fine if I just compare one variable (lets say product or customer).

But if I want to add a third layer (sales rep), it does not work as "this relationship has cardinality many-many"...

Please, can somebody explain how to manage the situation and make all the connections (sales rep, customer, product) between the tables.

Thanks a lot and have a great day!