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
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...