Hi ,
I am trying to achieve a row level security filter through analysis services tabular model using Lookupvalue function based on the two columns in a security table , where based value in either of one column the RLS should work,
'User'[Country]
= LOOKUPVALUE (
'Users'[Country],
'Users'[email], USERPRINCIPALNAME (),
'Users'[Country], 'FACT_TABLE'[Country]
)
&& 'User'[Region]
= LOOKUPVALUE (
'Users'[Region],
'Users'[email], USERPRINCIPALNAME (),
'Users'[Region], 'FACT_TABLE'[Region]
)
The filter need to check the value from both the columns. here would like to know whether (AND (&&)) operator will work in RLS or not.
Thanks.