Get all the values from one side to many side of the relationship

[ramchoudhary]

Hi Team,

I have three different tables and below is how they are connected.

My pbix. file is here - https://file.io/HlapG57rELb7

Below is the expected output:

deal_entity_id	developer_name	deal_instrument_name	total_capital_stack
21644	Developer1	deal_instrument_name1	$182000000
21644	Developer1	deal_instrument_name2	$182000000
21644	Developer1	deal_instrument_name3	$182000000
21644	Developer1	deal_instrument_name4	$182000000
21645	Developer1	deal_instrument_name5	$15000000
21786	Developer1		$10000000
21787	Developer1		$10000000
21788	Developer1		$20000000
21789	Developer1		$15000000
21790	Developer1	deal_instrument_name6	$7500000
22063	Developer1		$15000000
22064	Developer1		$182000000
22463	Developer1	deal_instrument_name7	$15000000
22464	Developer1	deal_instrument_name8	$20000000
22480	Developer2	deal_instrument_name9	$18000000
22531	Developer1	deal_instrument_name10	$10000000
22549	Developer1	deal_instrument_name11	$125000000

Where as I am geting below output in PBI as of now.

deal_entity_id	developer_name	deal_instrument_name	total_capital_stack
21644	Developer1	deal_instrument_name1	$182000000
21644	Developer1	deal_instrument_name2	$182000000
21644	Developer1	deal_instrument_name3	$182000000
21644	Developer1	deal_instrument_name4	$182000000
21645	Developer1	deal_instrument_name5	$15000000
21790	Developer1	deal_instrument_name6	$7500000
22463	Developer1	deal_instrument_name7	$15000000
22464	Developer1	deal_instrument_name8	$20000000
22480	Developer2	deal_instrument_name9	$18000000
22531	Developer1	deal_instrument_name10	$10000000
22549	Developer1	deal_instrument_name11	$125000000

The output in the PBI currently is giving us only the matching records but we need ot have all the records where " deal_instrument_name" is blank as well and dispplay the available data from "deal" as shown in my expected output 

[ramchoudhary]

select "show items with no data" does not work as it gives blank values for the deal data. Here is the snapshot of what we see when we clickn on "show items with no data" unlike our expected output.

[parry2k]

@ramchoudhary select "show items with no data" and that will do it.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!