cancel
Showing results for 
Search instead for 
Did you mean: 
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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors