3 Level Dynamic RLS

[Anonymous]

Hi All, 

I have the attached .pbix file that I'm trying to configure RLS for here. The TerritoryAssign table is maintained by our Sales Admin team, and I'm trying to find a solution where I don't have to reformat that table (if possible).

Here's the issue: I've seen many solutions that use RLS with two columns of data - Child and Parent. In the attached, I have three levels of a hierarchy - territory, district, and region. I cannot figure out the correct DAX formula to validate the RLS with these three levels.

Any help would be much appreciated!

[Jeff_Schlutz]

@Anonymous,

Try using the Switch function which is essentially the DAX equivalent of a nested if statement.

SWITCH( userprincipalname(), [Sales Person Email], [Sales Person Email]=USERPRINCIPALNAME(), [District Manager Email], [District Manager Email]=USERPRINCIPALNAME(),[Regional Manager Email], [Regional Manager Email]=USERPRINCIPALNAME())

Best regards,

Jeff

[v-chuncz-msft]

@Anonymous,

You may try using LOOKUPVALUE Function.

• https://community.powerbi.com/t5/Desktop/Row-level-security-to-see-organization-data-for-different-users/m-p/372051#M168773
• https://community.powerbi.com/t5/Desktop/Row-Level-Security-and-Slicer/m-p/449196#M207907

[Anonymous]

Thanks for the reply  @v-chuncz-msft.

Unfortuntely, this solution doesn't look like it will work, because I'd have to return the UserPrincipalName() from three separate fields.