Power Bi select all from left

[cottrera]

Hi

I have two data tables Master Data Table and Comments Data Table both with connected via a relationship with the reference number.

I want to display the following fields in a final visual table Reference Number, Status and Comments

However when I add the Comments field the amount of lines reduces as some of the reference numbers will not have comments next to them. The final visual talbe is ignore the ones with no comments and only diplaying the ones with comments. I am asuming its ti do with not showing left join?

Master Data Table
Reference Number	Status
112233	Legal 1
223344	Legal 1
334455	Legal 2
445566	Legal 2
556677	Legal 1
Comments Data Table
Reference Number	Comment
112233	Letter sent
223344	Court action
Results Visual Table
Reference Number	Status	Comment
112233	Legal 1	Letter sent
223344	Legal 1	Court action
334455	Legal 2
445566	Legal 2
556677	Legal 1
What I am actually seeing
Reference Number	Status	Comment
112233	Legal 1	Letter sent
223344	Legal 1	Court action

can you please help

RIchard

[amitchandak]

@cottrera , to create left join we add +0 or try this option

[cottrera]

Thank you for your quick response your suggestion also works fine 

[Greg_Deckler]

Perhaps create a Comments measure, something like:

Comments Measure = IF(ISBLANK(MAX('Comments Data Table'[Comment])),"none",MAX('Comments Data Table'[Comment]))

Use that in your visual instead of the Comment column.

[cottrera]

Thank you for your quick response your suggestion works fine 😀