I am working on Dynamic row level security.
The requirement is, if the Username() is present in Emp_ad then evaluate table 1 expression else evaluate table 2 expression.
1st expression is:
VAR user_Var=CALCULATETABLE (VALUES ( WC_EMPLOYEE_HIERARCHY_DASH_DI[emp_ad] ),WC_EMPLOYEE_HIERARCHY_DASH_DI[Supervisor_ad] =
)RETURNEmpIds[emp_ad] IN user_Var
2nd expression is:
))returnproxy_Table[proxy_username] in proxy
Both are working fine individually but I want to add the condition that if username() present in 1st table then evaluate 1st expression if not then 2nd expression.
I tried something like below but its not working. Can anyone please help me on that?
VAR user_Var=if(CONTAINS(WC_EMPLOYEE_HIERARCHY_DASH_DI,WC_EMPLOYEE_HIERARCHY_DASH_DI[emp_ad] ,
username())),CALCULATETABLE (VALUES ( WC_EMPLOYEE_HIERARCHY_DASH_DI[emp_ad] ),WC_EMPLOYEE_HIERARCHY_DASH_DI[Supervisor_ad] =
username())),if(CONTAINS(Proxy_Table, Proxy_Table[Username] ,username())),
CALCULATETABLE (VALUES ( proxy_Table[proxy_username] ),username()))))RETURN
if((CONTAINS(WC_EMPLOYEE_HIERARCHY_DASH_DI,WC_EMPLOYEE_HIERARCHY_DASH_DI[emp_ad] ,username()))), EmpIds[emp_ad] IN user_Var,
proxy_Table[proxy_username] in user_Var)
Even I got stuck at this step however found the solution while trying. Please use if you are still looking for this solution
you can create a third variable and provide OR condition in filter and call this variable in return
This is the variable you have to create which will select either from vtable1 or vtable2
Please mark as solution if this helps you 😊
@Rinku21 , I doubt you can username in calculate table. But you should be able to use in table inside measure
Hi @amitchandak ,
Thanks for your reply. I added username() just to simplify the expression. I am not using username() instead I am using below expression:
If ( IFERROR(SEARCH("@",USERNAME()),-1) <> -1,
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.