Dynamics RLS

[Anonymous]

Hi,

I am looking at RLS for looking at a user’s id and matrix security level and filtering on it less and equal to.

I have started to look at this I can filter by the user id fine, but I need to also filter on a second table for the security.

I can do this with the desktop via a page level filter, but I am unable to replicate this to the DAX statement in the RLS role.

This is what I have started to build but I am unsure if this is the correct way of doing this?

If(
Filter(
'user_data_rls (3)',
'user_data_rls (3)'[ntid]=userprincipalname())
,'user_data_rls (3)'[metric_securty_level] <= RELATED ('metrix_security_temp'[metrix_no]) 
) 

Any help will be great.

Thanks

[v-piga-msft]

Hi @Anonymous,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @Anonymous,

Please refer to this blog which describe Dynamic RLS in more details and introduce how to write the Dax for RLS.

Best  Regards,

Cherry