Forum Discussion
Solved
Relationship not linking data correctly
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 o...
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.⚡
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 |