Forcing a table in a join to be used in a table view

[Anonymous]

I have a SQL query which I am trying to replicate in Power BI

1. There's 5 tables of which 2 of them are not involved in the report 

2. Business wants this join to be used as it filters a set of records

3. I tried including a column and hiding it by reducing the size, but because of the cardinality, record numbers go up

4. I tried using USERELATIONSHIP function but its not about calculating one measure its about the entire report (table view) filtered by these joins

can we force the query to include the other two tables in the table view data generation.

[edhans]

If you want to filter out records in one table based on data in another table, the best place to do this is in Power Query, which supports joins. The DAX model doesn't use Joins in the same way SQL and other relational databases do. Those are filters, and you can only use one at a time per table, as you've found, and inactive relationships cannot filter at all for slicers, etc.