Forum Discussion
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 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.
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.⚡
4 Replies
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 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.⚡
