Group by based on specific values criteria

Hi, 

I am a new Power BI user, And I am trying to achieve the following:

I have the following main table (example):

 ID  |   SUB_FEATURE  | 

 1                A

 1                B

 1                C

 2                A

 2                B

 3                A

 4                A

 4                C

I have the following 3 tables that defines sets of sub-features to feature:

FEATURE_@

A

FEATURE_#

A

B

FEATURE_$

A

B

C

I need to create a new table that groups the ID to feature using the definition table:

 ID  |  FEATURE  | 

 1             $

 2             #

 3             @

 4             $

for each ID in the main table, I'd like to see what sub-feature it has, and based of the sub-fetures list, check which feature does it match.

Wasn't able to find similiar example in the forum.

Thanks in advance!

Jafar