Forum Discussion

michaelu1's avatar
michaelu1
Icon for Advocate II rankAdvocate II
2 years ago

RLS Help

I have the below scenario where I have a property table that filters 3 other tables: Requisitions, POs, and Invoices.   Ideally I would want that there should active relationships from the Req > PO...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi michaelu1 ,

 

From your description, the relationship between the User table and the other three tables must exist and be active, and the three tables must also have active relationships with each other, which always seems to trigger the relationship passing rules (relationships can only be passed to the same table along a single path), which may require a redesign of your model.

 

Also try replacing INTERSECT with the TREATAS function:

TREATAS – DAX Guide
Propagating filters using TREATAS in DAX - SQLBI

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group