Telling if data belongs to a specific category, or if is a member of parent category

[Zyg_D]

This is my data: 

How to make a new column in Table3 which would tell that the Category (in Table3) was selected (Table2 shows it) OR it belongs to a group of the selected category (Table1 shows it)?

The tables have no relationships. 

This is how Table3 should look after adding this column: 

[Zyg_D · Accepted solution]

Did it myself during this hour 🙂 

answer = 
VAR _x = LOOKUPVALUE ( Table1[Group], Table1[Category], Table3[Category] )
RETURN
    CONVERT (
        MAXX (
            FILTER (
                Table3,
                _x = LOOKUPVALUE ( Table1[Group], Table1[Category], Table3[Category] )
            ),
            IF ( 
                NOT ( ISBLANK ( _x ) ), 
                INT ( CONTAINS ( Table2, Table2[SelectedCategory], Table3[Category] ) ),
                0
            )
        ),
        BOOLEAN
    )