How to filter when slicer table does not have direct relationship with the to be filtered table

Thanks for your response

The sales table actually is a dimension table with the names of all sales reps

I have a date table connected to the table of "bookings and pipeline" ( fact table ), the issue is that I cannot connect it to the sales table because it shouldn't have a date as it has only the information of the sales rep

"Sales Rep" table is called in the above screenshot = "CEEMETA SFDC Sales Roster"

I used this ""CEEMETA SFDC Sales Roster"" table to create a calculated column and check the bookings and pipeline with the filters shown in the screenshot of every sales rep so I would be able to create a % of who did have booking and pipeline and who did not

There could be a better way to do it, but it dd not occur to me..