Forum Discussion

cottrera's avatar
cottrera
Post Prodigy
6 years ago

Power Bi select all from left

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 NumberStatus 
112233Legal 1 
223344Legal 1 
334455Legal 2 
445566Legal 2 
556677Legal 1 
   
   
Comments Data Table 
Reference NumberComment 
112233Letter sent 
223344Court action 
   
   
Results Visual Table
Reference NumberStatusComment
112233Legal 1Letter sent
223344Legal 1Court action
334455Legal 2 
445566Legal 2 
556677Legal 1 
   
   
What I am actually seeing
Reference NumberStatusComment
112233Legal 1Letter sent
223344Legal 1Court action

 

can you please help

 

RIchard

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    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's avatar
      cottrera
      Post Prodigy
      6 years ago

      Thank you for your quick response your suggestion works fine 😀

    • cottrera's avatar
      cottrera
      Post Prodigy
      6 years ago

      Thank you for your quick response your suggestion also works fine