Joining two tables without filtering

[moesteez]

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

[Thim]

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. 🙂

[MartynRamsden · Accepted solution]

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.

[yoavmor]

this saved me from re-doing my entire 50-table report. thank you.

[moesteez]

Thank you! @MartynRamsden