Relationship not linking data correctly

[Turf03]

Hey all!

Im trying to create a matrix showing employee performance and the organization they work for. The employee performance table just has the employee name, sales performance and date. The organization table has just the employee name and their organization. When I create the matrix summarizing their data, the employee is showing data for each organization even if they aren't in it. There is a Many to One relationship on the employee name in each table.

Is there any suggestions on how to link the two tables correctly and only show data for the employee for the segment they actually belong to? Im assuming there is something relating to the date data. 

[parry2k · Accepted solution]

@Turf03 solution attached

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Turf03]

@parry2k thank you for the example. I actually figured out the solution. I used the names off the Department table instead of off the performance tables and it worked as expected. 

[Turf03]

Below is an example of each table and Matrix results.

The one to many relationship is linked by Employee field

Employee Sales table

Date	Employee	Sales
01/01/2021	Smith, John	100
01/02/2021	Doe, Jane	50

Employee Department Table

Employee	Department
Smith, John	Electronics
Doe, Jane	Athletics

Matrix results (which are incorrect)

Month	Employee	Department	Sales
January	Smith, John	Electronics	100
January	Smith, John	Athletics	100
January	Doe, Jane	Electronics	50
January	Doe, Jane	Athletics	50

[parry2k]

@Turf03 I assume the organization table is on one side of the relationship? Correct?  Can you post some sample data. From which tables you are using columns in the matrix visual?