Merged columns not behaving as expected

[PCarson00]

I have two tables, merged into one. Now when I produce a table visual in power BI, I filter by certain criteria. It looks fine except one of the columns is not behaving as it should.

Now when I filter by one type, in my example below column A - isolating AA1 - It should be producing duplicate values in column C from the original data source but instead it is giving different values.

Unfortunately I cannot provide the real data but hopefully this is enough to explain? Table 1 and 2 merge to bottom table.

[amitchandak]

@PCarson00 , Looking at data it should be two column join, you can select second column in merge by using Ctrl+click

If not what is expected output on sample data

If this does not help
Can you share sample data and sample output in table format?