RLS When User Key Appears in either To OR From Columns

[AshPeep]

Background: I have Dynamic RLS sucessfully set up across a broad number of workforce tables using the branch (org code) and the supervisor's UPN to limit access for our department workforce data to only the supervisors of each org code. It works fantastic for 99% of my tables because Org is always a single column.

However, in the 3rd example table I have at the bottom, I have an Org TO column and an Org FROM column for tracking temporary assignments between orgs.

I need my managers to be able to view data from that table for employees on temporary assignment both into and from their org as there are responsibilities involved for both the receiving org and the losing org supervisors. I've only been able to model the relationship from the Supervisor Row Access Table to the Temporary Assignment table using one or the other column, and so far the advice I've turned up online is to create separate tables for Assignments IN and Assignments OUT. This is possible, but it would mean much, much more work as this data affects several other visuals in our reports. 

What I'm hoping for: Is there a way for me to set up a conditional relationship between the Supervisor Row Access Table and the Temporary Assignment Table where the supervisors have access to rows where their Org appears in either the Org From column OR the Org To column? Any help is appreciated!

Supervisor Row Access Table:

User	Org	UPN
Supv Name	Branch They Supervise	Email
Name	Branch They Supervise	Email

Sample basic workforce table 

Org	Employee	Grade
Branch	Employee Name	GS Level
Branch	Employee Name	GS Level

Temporary Assignment Table

Org FROM	Employee	Org TO	Effective Date
Branch	Employee Name	Branch	Date
Branch	Employee Name	Branch

[DataInsights · Accepted solution]

@AshPeep,

Add this DAX to the role for table Temporary Assignment:

[Org FROM]
    IN SELECTCOLUMNS (
        FILTER (
            'Supervisor Row Access',
            'Supervisor Row Access'[UPN] = USERPRINCIPALNAME ()
        ),
        "Org", [Org]
    )
||
[Org TO]
    IN SELECTCOLUMNS (
        FILTER (
            'Supervisor Row Access',
            'Supervisor Row Access'[UPN] = USERPRINCIPALNAME ()
        ),
        "Org", [Org]
    )

Temporary Assignment should not have a relationship with Supervisor Row Access (otherwise it would cause filtering to occur on only the column in the relationship).

[AshPeep]

This is fantastic, thank you so much!