Group by based on specific values criteria

[Anonymous]

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

[v-piga-msft]

Hi @Anonymous,

By my tests, the last solution of Greg_Deckler should achieve your requirement.

In addition, you also could have a reference of my attachment. I append your three tables as a new table in Query Editor.

Best  Regards,

Cherry

[Greg_Deckler]

Not 100% but I feel like this is close. Needs some tweaking.

[Greg_Deckler]

Here is another approach, again, close but not quite there.

[Greg_Deckler · Accepted solution]

OK, I think this is the one "Measure 2".