Forum Discussion

vengadesh_p's avatar
vengadesh_p
Helper II
1 year ago
Solved

One to Many Relation Ship Issue

Hello Everyone,  I have a table like the image below  Have a connection like this My expected output is  but I'm getting below result  How can I achieve this re...
Need Help
  • powerbiexpert22's avatar
    powerbiexpert22
    1 year ago

    Hi vengadesh_p 

    please follow below steps to get the output, please see below pbix file for your reference

    https://drive.google.com/file/d/16sf3HBGwfC7fN53bkeanKhMZEGN8xvjK/view?usp=drive_link

     

    1. create relationhip between two tables using id column 

    2. use drop down menu on name column and use count distinct as shown below

    3.  use the dropdown menu of id column and select show items with no data as shown below 

     

     

    If there are blank values in visuals, they will be hided by default. It is by design for Power BI. So, after creating relationships, you need to turn on the option "Show items with no data". 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi vengadesh_p ,

 

You need to change the relationship to both:

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.