cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PK_W_T Frequent Visitor
Frequent Visitor

Filtering a Query Based on a Related Table

I have imported a table into PowerBI as a query.  I have a distinct table with a list of projects.  If the project name is listed within this table, I would like to have that line removed from the query.  I have the table and query linked by the project column.

1 ACCEPTED SOLUTION

Accepted Solutions
PK_W_T Frequent Visitor
Frequent Visitor

Re: Filtering a Query Based on a Related Table

I added a column not through the query editor:

 

B&R = IF(

COUNTROWS(

FILTER(Table2,

SEARCH(Table2[Project],

Prospects[PROJECT], 1, 0)

)

),

1,

0

)

2 REPLIES 2
PK_W_T Frequent Visitor
Frequent Visitor

Re: Filtering a Query Based on a Related Table

I am trying to at least add a custom column within the Prospects table that will tell me if the project is contained in the Prospects query and table2.

 

CONTAINS(Table2, Table2[Project], Prospects[Project]))

It says expression.error. The name Contains is not recognized.

PK_W_T Frequent Visitor
Frequent Visitor

Re: Filtering a Query Based on a Related Table

I added a column not through the query editor:

 

B&R = IF(

COUNTROWS(

FILTER(Table2,

SEARCH(Table2[Project],

Prospects[PROJECT], 1, 0)

)

),

1,

0

)