link alternate part numbers

Hi aris 

First add a custom step in Table B to transform it into the following format. 

= Table.Combine({#"previous step", Table.AddColumn(Table.SelectColumns(#"previous step", {"partno"}), "alternate partno", each [partno])})

Then create relationships:

Table A (partno) 1-->* Table B (partno)

Table B (alternate partno) 1-->* Table C (partno)

Create a measure as a flag. Apply it to the second table visual as a filter and set it to show items when value is 1. 

flag = IF(ISFILTERED('Table A'[partno]),1,0)

I have attached a sample file at bottom. Hope it helps. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.