Forum Discussion

jasperj101's avatar
jasperj101
Helper I
1 year ago

Bi-Directional Filter Behaviours

Good Afternoon All,    I have come across some issues when using bi-directional relationships, it would be great if you could share some explanations and further reading sources to help me understa...
Need Help
danextian's avatar
danextian
Super User
1 year ago

Hi jasperj101 

 

I tried to mimic your table but I think I am missing something as my test shows that ALL applied to customers returns ALL regardless of the filters applied to it from either of the other tables.

It is always a good practice to post a sample data/pbix and not just images. That aside, try including ALL (Tags) inside CALCULATE as well.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi jasperj101 

     

    When enabling the bidirectional cross filter, once you filter one table, you also filter all the tables on the “one” side of a relationship.

    So when you filter rows on Tags, you implicitly filter Territories and Customers, thus affect the result.

    Here is a sample for your reference:

    Row Context and Filter Context in DAX - SQLBI

    To solve this, you can add a ALL(Tags) to clear the implicit filtering:

     

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • jasperj101's avatar
      jasperj101
      Helper I
      1 year ago

      Hi Anonymous, 

       

      Many thanks for the reply, the solution you have provided is the way I have already solved this. 

       

      However, I am still not understaning the different ways the implicit filtering is working in this model. Am I correct that the definition of implicit filtering is a filter that has propagated through a relationship from an explicit filter in another table? 

       

      If that is correct, the implicit filter that propagates from Territories > Customers through the many to one relationship gets ignored when using ALL(Customers). However, the implicit filter propagating from Tags > Customers through the many to one bi-directional filter does not get cleared by ALL(Customers), still not understanding why the bi-directional relationship acts differently...