Forum Discussion
Joining two tables without filtering
Hi,
I feel like this should be easy but for the life of me cant seem to work it out.
I have two tables 'Employees' and 'Training'
Emplyees looks like:
| EmployeeID | EmployeeName |
| 1 | Gary |
| 2 | Ben |
| 3 | Mary |
Training looks like:
| TrainingProgramID | EmployeeID | TrainingProgramName |
| 9 | 1 | Service |
| 8 | 3 | Safety |
If I join the tables and create a table with the EmployeeName and TrainingProgramName what I see is:
| EmployeeName | TrainingProgramName |
| Gary | Service |
| Mary | Safety |
But I what I want to see is all the employees, so that:
| EmployeeName | TrainingProgramName |
| Gary | Service |
| Ben | |
| Mary | Safety |
Does anyone know how I can get this result without filtering out the employees that dont also exist in the training table?
Thanks
David
Hi moesteez
Click on the table visualisation and then, on the Visualisations pane, click the down arrow on 'EmployeeName'.
Select the option to 'Show items with no data'.
Your missing rows will then appear.
Best regards,
Martyn
If I answered your question, please help others by accepting it as a solution.
4 Replies
Hi moesteez
Click on the table visualisation and then, on the Visualisations pane, click the down arrow on 'EmployeeName'.
Select the option to 'Show items with no data'.
Your missing rows will then appear.
Best regards,
Martyn
If I answered your question, please help others by accepting it as a solution.
Thank you! MartynRamsden
this saved me from re-doing my entire 50-table report. thank you.
How has Power BI choosen to handle your values?
When i made the table, it sometimes choose the setting "First TrainingProgramName"
When it did this, i got the same result as you.
When i change this from "First" to "Don't Summarize" I got the names of those without any Training Programs.
Hope this will help. 🙂
