Forum Discussion

DanCasSan20's avatar
DanCasSan20
Regular Visitor
2 years ago
Solved

Apply filter with RSL

Hello community!   I have a model, which I need to filter by user and year; However, when I configure my RSL it does not filter my data.     As you will see in the image, I have created a ...
Need Help
Tips and Tricks
Tutorial Requests
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    Hi DanCasSan20 ,

     

    If a user has permissions for multiple roles at the same time, his permissions are the union of multiple roles.
    So, when testing, you should only choose one roles.

     

    And, you can try below RLS expression on DIM_TIMEPO:

     

     

    IF(USERNAME()<>"[email protected]",TRUE(),'DIM_TIMEPO'[Year]>=2023)

     

     

    Also, you can enable security filtering options when establishing relationships.

     

     

     

    Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

     

    Thank you~

     

xifeng_L's avatar
xifeng_L
Icon for Super User rankSuper User
2 years ago

Hi DanCasSan20 ,

 

If a user has permissions for multiple roles at the same time, his permissions are the union of multiple roles.
So, when testing, you should only choose one roles.

 

And, you can try below RLS expression on DIM_TIMEPO:

 

 

IF(USERNAME()<>"[email protected]",TRUE(),'DIM_TIMEPO'[Year]>=2023)

 

 

Also, you can enable security filtering options when establishing relationships.

 

 

 

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

 

Thank you~