Understanding a Conflicting Filter Situation

[Anonymous]

Hello,

I have a conflicting filter situation that I'm having trouble understanding. I would appreciate any help.

I have a date table, a fact table, and a users table.

Here are the relationships in place:

• The date table has a 1:n relationship with the fact table on a date column.
• The users table has a 1:n relationship with the fact table on a user column.

I'm wanting to filter a display by both the date column from my date table and the user column from my users table. However, ever time I try to filter by the user column from the users table, the date filter empties out. For some reason, I can't filter by both the date and the user (from the users table).

What could be causing this?

Some potential causes I've thought of:

1. My users table has relationships with other fact tables and those fact tables also have a relationship with the date table on the date column. Could this be causing issues?
2. My users table has some rows that don't have any rows in the fact table. Could this be causing issues?

Thanks for your time.

-Caleb

[amitchandak · Accepted solution]

@Anonymous , do you have a bi-directional relationship? If yes, make them single direction. This should not happen in case the date is coming from the date table and the user from the user table in a single direction relationship.

[Anonymous]

@amitchandak , the fact table I am currently working with doesn't have a bi-directional relationship.

However, one of the other fact tables that is connecting to the user and date table does have a bi-directional relationship between the fact and date table. I have found that when I remove the users table relationship to this particular fact table, then I can filter by both the user column and date table.

I don't understand bi-directional relationships enough to understand why this causes a conflict with the filter. I'll have to learn more to understand this.

But more importantly, now I need to understand why PowerBI is forcing this one fact table to have a bi-directional relationship with the date table. I am unable to do a single direction relationship for some reason. I will research this, but if you have any thoughts on this, I'm all ears.

Thank you for your quick response and help!

-Caleb

[amitchandak]

@Anonymous ,what error does it give when change the date table relation single directional.