Forum Discussion

Devender9999's avatar
Devender9999
Frequent Visitor
3 years ago

How to use selectedvalue in RLS

Hi Experts, I have a case where I need to exclude one material from Product category when a  X type user logins but not exclude when other users login,    X is a column in RLS table having values ...
Data Protection
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi,

You can achieve this by maintaining a table having the email ids in one column and user type in another column. For example, Admin (User type) should be able to see all values, for that the following DAX has to be used:

Restrict User =
VAR UserCategory =
    CALCULATETABLE (
        VALUES ( 'USER_ACCESS'[USER_TYPE] ),
         'USER_ACCESS'[EMAIL_ADDRESS]= USERPRINCIPALNAME()   )
RETURN
if(UserCategory="Admin",Materials[Material_Name],"Restricted")
Likewise we can restrict the User based on what he/she wants to view.
  • Devender9999's avatar
    Devender9999
    Frequent Visitor
    3 years ago

    Thanks for response, I am able to restrict when X type users logins and if admin or Y, Z type user login they can see the material but what i need that when a Admin logins then he can see what visible to X type an what visible to Y or Z 

    Let say we have three product Pen-- 10

                                                     Pencil ---20

                                                     ruler --- 30

    so when X logins he see only pencil and ruler let says sum of 20+30 = 50
     and when any one else logins He sees all pen, pencil and ruler , 10+20+30= 60

     

    now i have scliers of X (x1,x2,x3 ) and similary sclier for Y and Z 

    Now a admin who has access to all data what to see what visible to X users and select x1 from sclier he should see only pencil and ruler not pen 

    but when select a value from Y or Z then he see all pen,pencil and ruler

     

    can we achive this?