RLS if-statement on USERPRINCIPALNAME

Hi Anonymous ,

In Manage roles, you can create new roles and try this DAX pression to solve your problem:

IF (

    CALCULATE (

        COUNTROWS ( 'Table' ),

        FILTER ( 'Table', 'Table'[email] = USERPRINCIPALNAME () && [IsTeamlead] )

    ) > 0,

    [Country]

        = CALCULATE (

            MAX ( 'Table'[Country] ),

            FILTER ( 'Table', 'Table'[email] = USERPRINCIPALNAME () )

        ),

    [email] = USERPRINCIPALNAME ()

)

When you use View as roles, you will get the following result:

Here is the demo , please try it:

PBIX 

Best Regards,

Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.