Need to filter dimension table (Clients Table) by fact tables (Loans, Deposits and etc.

[IOdzelashvili]

Hello Power BI Community!

This is my model: I have a Clients table containing all unique clients, with one-to-many relationships to several fact tables (like deposits, loans, etc.).

In my report, I have a table visual that includes columns from only the Clients table, along with multiple slicers. These slicers contain filters from the Clients table and also filters from the Loians, Deposits, Accounts and etc. As you know, with this model, it is impossible to filter my table visual using slicers from the Loans table. I do not want to create many-to-many relationships and change the direction of my relationships.

Can you help me achive the desired functionality? I hope I have described my problem clearly. If you have any questions, please let me know.

[IOdzelashvili]

Thank you.

Just a little correction:

Measure test =

VAR SelectedClients = VALUES(Clients[ClientID])

RETURN IF(MAX(Loans[ClientBID) IN SelectedClients, 1, 0)

[Anonymous · Accepted solution]

Hi @IOdzelashvili ,

Create a DAX measure that checks if the selected value from the slicer in the Clients table matches any value in the Loans table.

Measure = 
VAR SelectedClients = VALUES(Clients[ClientID])
RETURN IF(MAX(Loans[LoanID]) IN SelectedClients, 1, 0)

Apply it to visual filter.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.