RLS Rules

[SuRe]

Hi all,

I want to set up a RLS for our sales persons. In my main report I show sales revenue and budget figures as well as customers and similiar. With the RLS I want to filter by this sales person. He should see either his own data or total company data, but not the data of each separate other sales person.

my filter would be: (AN are the credentials of the sales person)

[ASM] = "AN"

But how to include the total numbers? I tried

[ASM] = "AN" || [ASM]="*"

But this does not work.

Any ideas?

[GilbertQ]

Hi @SuRe 

Currently, it is not possible to do this with the built in functionality of row level security. If you wanted to do this, you would need to create a workaround to facilitate this. Computing accurate percentages with row-level security in Power BI - SQLBI