Forum Discussion

menphis21's avatar
menphis21
Helper IV
3 years ago
Solved

Dynamic security rules with specific hierarchy

Hi,   I have a table of aging account and also a table of each email of all the employees as below : Client Amount Managing Parter Partner Senior Manager Chairman A 1000 X Y Z XY ...
Need Help
menphis21's avatar
menphis21
Helper IV
3 years ago

Hi,

 Anyone ?

 

Iam trying also to find a way to user the function filter like that :

if(CONTAINS(Aging,Aging[Chairman Email],USERPRINCIPALNAME()), filter(Aging,Aging[Chairman Email]=USERPRINCIPALNAME()),
if(CONTAINS(Aging,Aging[Manager Email],USERPRINCIPALNAME()), filter(Aging,Aging[Manager Email]=USERPRINCIPALNAME()),0))

but didnt work.

 

Thank you in advance for your help