Filter applied on a Table is not taking effect on another table with relationship 'Many to One'

Hi  Anonymous ,

As far as I know, using bridged tables is the quickest way to encounter this situation

If there are multiple relationships between these tables and the active table doesn't allow the filter to propagate as desired, you might consider using the Related() or Userelationship() functions.

RELATED function (DAX) - DAX | Microsoft Learn

USERELATIONSHIP function (DAX) - DAX | Microsoft Learn

Ensure that the relationship between the Shop table and the Employee table is set up correctly to allow filtering as expected. Sometimes the presence of inactive relationships or complex model structures can prevent the expected filter propagation.

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

This is the related document, you can view this content:

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-bidirectional-filtering

https://community.fabric.microsoft.com/t5/Desktop/Row-Level-Security-Error/td-p/2249910

https://community.fabric.microsoft.com/t5/Desktop/Row-Level-Security-Unable-to-add-roles-because-of-cross-filter/td-p/2318517

Best Regards,

Liu Yang

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