cancel
Showing results for 
Search instead for 
Did you mean: 
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
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.