RLS with super user(kind of admin)

[Anonymous]

Hi Team,

I would request someone to help me with the issue I have. 

I have RLS implemented in a report like below  :

Role = User

DAX expression =

[useremail] = userprincipalname() 

|| if ( maxx (filter ( 'table', 'table'[useremail] = userprincipalname() ) ,

'table'[is_admin] ) = 0,

'table'[usereamil] = userprinicipalname(), TRUE )

This role is giving full access to the user who's [is_admin] = 1 and for others who's [is_admin] = 0, it gives only their information.

My question is when an admin(who's [is_admin] = 1) logs into the report, I need to show his details only instead of everyone's and only when he wants to view others he can search for others and see all data. 

[lbendlin]

This is what I get when I put your expression through DAXFormatter.com:

DAX expression =
'table'[useremail] = USERPRINCIPALNAME ()
    || IF (
        MAXX (
            FILTER ( 'table', 'table'[useremail] = USERPRINCIPALNAME () ),
            'table'[is_admin]
        ) = 0,
        'table'[useremail] = USERPRINCIPALNAME (),
        TRUE
    )

Are you sure this is what you wanted?

Usually in such scenarios you create separate roles for super users.