cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Jafar New Member
New Member

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Group by based on specific values criteria

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

 

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


4 REPLIES 4
Super User
Super User

Re: Group by based on specific values criteria

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

 

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Super User
Super User

Re: Group by based on specific values criteria

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

 

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Super User
Super User

Re: Group by based on specific values criteria

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

 

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: Group by based on specific values criteria

Hi @Jafar,

 

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.