Need to check if cell value in Column1 exists anywhere in Column2

[gummby8]

I have 1 table called "merged"

it contains 2 columns, Column1 and Column2

Column1	Column2
Cat	Fish
Dog	Rabbit
Fish	Dog
Rabbit
Big-Dog

If the cell from Column1 (Exact match, but preferably not case sensitive) is found anywhere in Column2 it should mark Column3 as True

Column1	Column2	Column3
Cat	Fish	False
Dog	Rabbit	False
Rabbit	Big-Dog	True
Fish		True
Big-Dog		True

[DataInsights · Accepted solution]

@gummby8,

Try this calculated column:

Column3 = 
VAR vColumn1 = Table1[Column1]
VAR vRowCount =
    COUNTROWS ( FILTER ( Table1, Table1[Column2] = vColumn1 ) )
VAR vResult =
    IF ( vRowCount > 0, TRUE, FALSE )
RETURN
    vResult