You Can't create a direct active relationship - two Relationships to filter using Slicer PowerBI

[Mr_Dhulfi]

Hello Everyone, 

I have two tables with the same content from different costumers. as shown in the example..

My goal was building two relationships as shown below, once with the date and once with the customers, to be able to filter the data by cusotmer name and by date using two slicers.

But Power BI is not accepting the second relationship and setting it into inactive (Between A1 and All_Customers):

The goal is to be able to filter by date and by customers.

Can someone solve this issue? Any other approaches?

[Anonymous · Accepted solution]

Hi @Mr_Dhulfi ,

1. The first method groups tables A1 and A2 by table name and appends them as one fact table in PowerQuery Editor. Then create relationships with the date table and the customer table.

2. The second method is to dynamically filter visual by measure and slicer. like:

A1_Temp = 
VAR _table = ALLSELECTED('All_Customers'[All_Customers])
VAR _value = CALCULATE([A1 Measure],'A1'[Customers] in _table)
RETURN
_value

A2_Temp = 
VAR _table = ALLSELECTED('All_Customers'[All_Customers])
VAR _value = CALCULATE([A2 Measure],'A2'[Customers] in _table)
RETURN
_value

relationships:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum