Instead of the "merge" option I would like an option to only "keep" the records from a table based on values that exist in another table after collecting it to the report.

in SQL terms this should work exactly as left/right/inner join, except not actual "joining" the table. The tables should still be two separate tables, power bi should just not load the rows that are not applicable for the "join".
Needs Votes