Forum Discussion

Helper I

5 years ago

Row Level Security

I have a Data Table as shown below :- Territory ID Value SKU ID 1 11 22 1 22 23 1 33 22 2 44 23 2 55 22 2 66 23 3 77 24 3 88 24 3 99 22 4 12 25...

Resident Rockstar

5 years ago

Try the below DAX in RLS,

Table - SKU:

IF(USERPRINCIPALNAME() IN VALUES(SKU[Email]),[Email]=USERPRINCIPALNAME(),TRUE())

Table - Territory:

IF(USERPRINCIPALNAME() IN VALUES(Territory[Email Id]),[Email Id] = USERPRINCIPALNAME())