Filtering table with USERNAME() for Row Level Security

Question

Hello community,I want to have a row level security that does this "Filter the units depending on the USERPRINCIPALNAME() units when the USERPRINCIPALNAME() is in a group containing "administration"."I wrote this DAX code that does what I want (note: units and groups are hierarchical subset of the company):&nbsp;&nbsp;&nbsp;[Units]
    = CALCULATE (
        LOOKUPVALUE ( 'Employee'[Group], 'Employee'[E-mail], USERPRINCIPALNAME () ),
        FILTER ( 'Employee', CONTAINSSTRING ( [Groupe], "Administration" ) )
    )&nbsp;&nbsp;&nbsp;Unfortunately, "USERPRINCIPALNAME()" cannot be used inside of a Calculate function if I believe the error.How can I refactor to obtain the result that I want?Best regards,

lbendlin · Answer

You don't.&nbsp; Apply RLS to your dimension tables and let the data model do the work for you.

anonymous · Answer

Thank you for your answer.&nbsp;Then, what would the DAX code look like to filter with the string "administration"?

lbendlin · Answer

pretty much the same as you show. Just as a RLS rule, not as a measure.

anonymous · Answer

The DAX code that I wrote was written as a RLS rule and not a measure already.

Forum Discussion

Filtering table with USERNAME() for Row Level Security

4 Replies

Related content

Filter Table by Username Without Row Level Security

Filter Dashboard by UserName

filter on a page usign USERNAME()?

Role Level Security

Governance & Security