Forum Discussion
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...
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".
1. Make relationship bi-directional
2. Use ID from Dim Table in your matrix
3. Right click on ID, and select "Show items with no data"
4. Measure:
# Name = DISTINCTCOUNT('Dim Table'[Name])
This is my outcome: