Help Please - filter text, list multiple rows

[Langsam470]

Thanks in advance for your help.  I've having trouble trying to solve for this.  

In powerbi I have 3 data tables.

The “RFP Index” table has 2 columns, “Client” and “RFPID”.

The “Incumbent Vendors” table has 2 columns, “Incumbent” and “RFPID”

The “Winner Vendors” table has 2 columns, “Winner” and “RFPID”.

There is a 2 way relationship between the “RFP Index” table and “Winner Vendors” table and “RFP Index” and "Incumbent Vendors” table both using the "RFPID" column.   

Within the report review I have 3 tables and 2 slicers (see below).  Currently I can select any RFPID (top left table) and it will show all the Incumbents (bottom left table) and and winners (bottom right table).  However, I would like to be able to filter by either a specific Incumbent or Winning bidder and have the only filter the list of RFPID without impacting the bottom 2 tables.  

[Ray_Minds · Accepted solution]

Tt seems that you want to restrict the filter of two visualisations with respect to two slicers. so Power BI has the option to fulfill your requirements.
Please follow the steps below:
1. Go to the Format that shows on the home ribbon >>>> select edit interaction.
2. Now , you will select the slicer then show some new icons on the header options for all visualisations instead of your selected slicer.
3. You will just restrict the filter of visualisations as per your requirements.

[amitchandak]

@Langsam470 , try a measure like this in visual

Filtered IDs =
CALCULATE(
DISTINCT('RFP Index'[RFPID]),
FILTER(
'RFP Index',
'RFP Index'[RFPID] IN VALUES('Incumbent Vendors'[RFPID]) ||
'RFP Index'[RFPID] IN VALUES('Winner Vendors'[RFPID])
)
)

[Langsam470]

Thanks, but when using that I receive the following error: 

[Irwan]

If it only for visual, is it possible to just disconnect their relationship using "Edit Interaction"?

Select the slicer then choose the symbol in red circle in other visual then the other visual will not change to any selection in that slicer.

Thank you.