Forum Discussion
Solved
Toggle Row Level Securiy
Dear all, I have an application with the following data model : I have 4 RLS Tables : one for the hierarchy, one for the location, one for the country and one for the headcount. Basicall...
VAR _Selected_Role = VALUES(Param_Security_Role[Role]) -- User role selection
RETURN
_Selected_Role = "Hierarchy" && 'DIM_USER_RLS_HIERARCHY'[USER_EMAIL] = USERPRINCIPALNAME()
VAR _Selected_Role = VALUES(Param_Security_Role[Role])
This is a table, to return a single value use SELECTEDVALUE() or a aggregation like MAX()
VAR _Selected_Role = selectedvalue (Param_Security_Role[Role], "location")