Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
IF
Post Prodigy
Post Prodigy

Filter by another field

Hi,

 

I have two tables. Table 1:

NameType

AX1
AX1
BX2
BX3
BX4
CX2
CX3
CX3
CX1
DX1

 

Table2:

NameQty

A2
B3
C5
D7
E8

 

I want to connect the tables with the "name" column. If the name has X1 type value, I want to filter that name. In table 1, I have X1 value for A, C, D. Only Name:B doesn't have X1 type. Based on this I want to have a table, that shows Name and Qty, which should be B and the qty should be 3.

how can i a filter in 

1 ACCEPTED SOLUTION
Luis98
Resolver II
Resolver II

Hi @IF ,

 

I got this:

 

First you have to group Type by Name all rows, you would get this table:

Luis98_0-1669306930690.png

Then you have to get the column of Type from this column table as list, you can do it with this formula:

Luis98_1-1669307017577.png

 

Then you have to expand the list with "," delimited for example and remove the column table, you would have your table like this:

Luis98_2-1669307097629.png

Then you just have to merge with the other table by Name column, and filer the column of Types by Text Contain, and i get that i think you need:

Luis98_3-1669307163562.png

 

View solution in original post

1 REPLY 1
Luis98
Resolver II
Resolver II

Hi @IF ,

 

I got this:

 

First you have to group Type by Name all rows, you would get this table:

Luis98_0-1669306930690.png

Then you have to get the column of Type from this column table as list, you can do it with this formula:

Luis98_1-1669307017577.png

 

Then you have to expand the list with "," delimited for example and remove the column table, you would have your table like this:

Luis98_2-1669307097629.png

Then you just have to merge with the other table by Name column, and filer the column of Types by Text Contain, and i get that i think you need:

Luis98_3-1669307163562.png

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors