Forum Discussion
Helper IBi-Directional Filter Behaviours
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.
Helper IHi 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...