RelationShip Problem

[diogovaz]

Hi everyone,

I have this relationship (Team Members - Team - PCS Sales)

I want to use NET Sales in PCS Sales and Team ID and Sales Person from Team Members and the results are very bad.

If I use the Team ID in PCS Sales and Sales Person from the same table the values are alright.

For example:

And the main goal is to have a matrix that gives me the Team ID and Member from Team Members and Net Sales For Sales.

Thanks in advance,

Diogo

[v-huizhn-msft]

Hi @diogovaz,

Have you resolved your issue? If you have, please mark the reply as answer if you think it's useful. More people will learn new things here.  If you haven't, please feel free to ask.

Best Regards,
Angelia

[v-huizhn-msft · Accepted solution]

Hi @diogovaz,

I test and try to reproduce your scenario using your sample table second screenshot shown.

If I select the ID and Net Sales from one table: Sales Table, it shows the correct result as picture1 shown.



While for your requirement, you want to display the Team ID and Member from Team Members and Net Sales For Sales in a matrix, I create a matrix, it shows wrong result, because there is no accurate relationship between Members and Net Sales, there are N:N relationship,  ID connect to Members.



Best Regards,
Angelia