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.
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.
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.
