Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX Expression for Row Level Security

Help – I have the following tables. FUFPermission is a list of users and the area they can have access to. FUFPermission Username Area [email protected] Back [email protected] Front ...
  • v-jianboli-msft's avatar
    v-jianboli-msft
    4 years ago

    Hi Anonymous ,

     

    Please try:

    VAR _a =
    SELECTCOLUMNS (
        FILTER ( 'FUFpermission', [Username] = USERNAME () ),
        "Area", [Area]
    )
RETURN
    IF ( "All" IN _a, TRUE, [Area] IN _a )

    Final output:

    Best Regards,

    Jianbo Li

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

     

     

     

v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

 

Please try:

VAR _a =
    SELECTCOLUMNS (
        FILTER ( 'FUFpermission', [Username] = USERNAME () ),
        "Area", [Area]
    )
RETURN
    IF ( "All" IN _a, TRUE, [Area] IN _a )

Final output:

Best Regards,

Jianbo Li

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

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for the response - not sure if this woud work as there is no physical relationship between the tables FUFPermission and AFU.