Dynamic Row level security

[Anonymous]

Hi ,

I want to filter both hierarchies "region" and "product" in the DRLS like when User =1 I should only see Region= canada and Product = Amarilla and when User = 3 he should see all "Region" and "Product". Please can anyone help me with this scenario that will be helpful.

Thanks.

[v-janeyg-msft · Accepted solution]

Hello @Anonymous 

According to your desired result. I have a sample method you can refer.

First, you need  to create a e-mailmanager column in table.

Like this:

E-mailmanager =
MAXX ( FILTER ( table, [Region] = "ALL" && [Product] = "All" ), [Users] )

If this value is fixed, you can also directly write.

E-mailmanager = "xxx@xxx.com"

Then you can create the new role easily.

Like this:

[Users] = USERPRINCIPALNAME () || [E-mailmanager] = USERPRINCIPALNAME () 

Best Regards,

Community Support Team _Janey

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

[Anonymous]

Try This Measure
VAR colomn = if(Users[id]=1,1,0)
IF (
MAXX ( FILTER ( Users, Users[Email_id] = USERNAME () ), colomn ) = 1,
Users[Email_id] = USERNAME (),
1 = 1
)