How Compare values across rows in two columns

[KelzMaJ]

I am trying to create a new table that shows rows with matching data in two separate columns.

eg

Ice-cream flavour	Cake Flavour
Vanilla	Chocolate
Cookie Crunch	Cookie Crunch
Strawberry	Banana
Blackcurrant	Blackcurrant
Mint	Carrot

The result should be a table with the matching values such 

eg

Ice-cream flavour	Cake Flavour
Cookie Crunch	Cookie Crunch
Blackcurrant	Blackcurrant

[ERD · Accepted solution]

Hi @KelzMaJ , you can create a measure and use it for filtering the visual.

Measure:

Measure = 
IF ( MAX ('Table'[Ice-cream flavour] ) = MAX ( 'Table'[Cake Flavour] ), 1, 0 )

Filter:

[KelzMaJ]

Thank you so much, this worked!

[KelzMaJ]

Thank you, let me try and get back to you.