Issue with filter on multiple relationship between tables in model view.

[TcT85]

Hi,

Iam having issues with some filter that I beleive it is correlated on how I have setup the table relationsship in Model View.

I have 1 main table with 2 columns that are "responsible userID" and another column with "manage userID", to retrive the users name I have created 2 identical tables that contain name for userID that has relationship with "responsible userID" and another has relationsship with "manage userID".

But when I create a report with visualisations with user from "responsible" and user from "manage" they start to filter out each other.

The result I want is to be able to display both of them without filtering out each other.

Visualisation of model view.

In report visualisation:

How can I fix this?

[TcT85 · Accepted solution]

I solved this by using merge queries, to add the columns to main table.

[lbendlin]

The result I want is to be able to display both of them without filtering out each other.

That desired result is incompatible with the way Power BI works.  To implement "or" filters you either need to combine the dimension tables or use disconnected tables and measures as visual filters.