Filter 2 related tables

Hi Anonymous ,

We can use the merge function to meet your requirement.

Merge Table A and Table B in Power Query Editor based on Right outer.

Or if you want to show the output in a table visual like this,

You can create this measure and put it in Filter on this visual, configure the value is 1.

Measure = 
IF(
    MAX('Table A'[Invoice])=MAX('Table B'[Invoice]) &&
    MAX('Table A'[Date A])=MAX('Table B'[Date B]) &&
    MAX('Table A'[Center A])=MAX('Table B'[Center B]) &&
    MAX('Table A'[Value A])=MAX('Table B'[Value B]) && 
    MAX('Table A'[Weight A])=MAX('Table B'[Weight B]),1,0)

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

Best regards,

Community Support Team _ zhenbw

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

BTW, pbix as attached.