Help with table relation

[Kalachuchi]

So I have two tables Input and Output which has ID and Master ID as foreign key relating to each other.

My chart is showing output data while a table below is showing input data.

If I add output date (results) to the input data then the table only shows info of output while it should also include input table.

Input table:

ID	Name	Age
1	Arthur Morgan	22
2	Dutch Van der linde	32
3	Hosea Matthews	45

Output Table:

Master ID	Answer 1	Answer2
1	Yes	Yes
2	No	No

Problem is 

When I show the answer 1 on my column chart it shows 2 counts,

Expected output on Table:

Name	Age	Answer1
Arthur Morgan	22	Yes
Dutch Van der linde	32	No
Hosea Matthews	45

Problem is when I add answer 1 from Output Table, it only shows name who has only answered the questions. I want all input appear on the table even if answered or not.

ID and master ID are already connected on table relations.

Thank you for help

[Anonymous]

Is that what you're looking for? 

https://1drv.ms/u/s!AnIEh6WhI4JogrAAnyDVVkj51F1Xdg?e=v77bfY

I've created a sample PBIX to show you how to achieve this. essentially, I've just merged the two, together then replaced "null" with "No answer"

[Kalachuchi]

Did not know this merge function lol. It worked, thank you so much!

[Anonymous · Accepted solution]

can you share some sample data with us? 

It seems to work ok for me 

[Kalachuchi]

it does work, problem is I think the column chart is filtering the table since column chart only contains answered questions. It does not show Hosea.

[calerof]

Hi @Kalachuchi,

If you select Id from your Input table as axis and count Answer1 as values in a Column chart, make sure you expand the arrow in the Id field and select "Show items with no data", and you get this:

Hope it helps.

Regards,

Fernando

[Kalachuchi]

@calerof I am achieving to count the answers on the chart and full input list with answer on table.