Apply filter with RSL

[DanCasSan20]

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 filter where I have 2 conditions, if the user who logs in is different than "mailadmin@mydomain.com" the data should be filtered and only the information from 2023 onwards should be shown, but, When I validate this it does not filter the years and continues to show all the years.

Could you tell me what I'm doing wrong?

Thank you!

Rgds,

DC

[xifeng_L · Accepted solution]

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()<>"mailadmin@mydomain.com",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~