Forum Discussion

SaadYounus's avatar
SaadYounus
Frequent Visitor
4 years ago
Solved

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: 

Table2: 


Bridge table to filter both


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.


Relationship/Model

 


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

2 Replies

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

    • SaadYounus's avatar
      SaadYounus
      Frequent Visitor

      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.