USERPRINCIPALNAME() : USERPRINCIPALNAME() : Current user's UPN - use in RLS

USERNAME() : USERNAME() : Legacy username function

ISFILTERED() : ISFILTERED(Security[Dept]) : Check filters for security logic

ROLE SECURITY : FILTER(Sales, Sales[Region]=USERPRINCIPALNAME()) : Row-level security formula

HASONEFILTER() : HASONEFILTER(Dept[Name]) : Detect multiple selections for security

SELECTEDVALUE() : SELECTEDVALUE(Dept[Name]) : Return selected slicer value safely

GROUPBY RLS : KEEPFILTERS( Sales, Sales[Dept]=Employee[Dept] ) : Maintain filter within RLS

ISINSCOPE() : ISINSCOPE(Region[Country]) : Check hierarchy scope

CONTAINS() : CONTAINS(Sales, Sales[User], USERPRINCIPALNAME()) : Return TRUE if table contains row

LOOKUPVALUE() RLS : LOOKUPVALUE(Auth[Allowed],Auth[User],USERPRINCIPALNAME()) : Table lookup for permissions