Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Mr_Dhulfi
New Member

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

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):

 

Mr_Dhulfi_2-1671007329489.png

 

 

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

 

Mr_Dhulfi_1-1671006956714.png

Can someone solve this issue? Any other approaches?

1 ACCEPTED SOLUTION
v-cgao-msft
Community Support
Community Support

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:

vcgaomsft_0-1671089746143.png

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

View solution in original post

1 REPLY 1
v-cgao-msft
Community Support
Community Support

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:

vcgaomsft_0-1671089746143.png

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.