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
SaadYounus
Frequent Visitor

Slicer from Bridge table not filtering tables correctly

Hi, I have spent quite some time to resolve this but no success.

I've got two similar tables (but due to business reasons, cannot combine them, and need to show them as seperate tables). I am using a bridging table to filter these two tables but the tables are not filtering properly.

Table 1: 

SaadYounus_0-1664498943014.png

Table2: 

SaadYounus_1-1664498990263.png


Bridge table to filter both

SaadYounus_2-1664499026804.png


Measures

isfinal = if(Sum(Table1[UnconfirmedCount]) = 0, "FINAL", BLANK())
IsFinal2 = If(SUM(Table2[UconfirmedCount]) = 0,"Final", Blank())

Bridge table filter not filtering class correctly. Any help will be highly appreciated. Thanks.
SaadYounus_3-1664499183690.png


Relationship/Model

SaadYounus_0-1664501158703.png

 


Desired Result:
When I select A in the bridge class slicer, only A displays in the matrix visuals and so on.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@SaadYounus , Hope you are using the class from Bridge Table in visual . Also make Join as single directional

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@SaadYounus , Hope you are using the class from Bridge Table in visual . Also make Join as single directional

Hi Amitchandak
Thanks using Class from Bridge table in table visuals works. 
But any idea why did it not work with Class from tables in matrix visuals.

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.