Bypass RLS for a measure

[Anonymous]

Hi everyone, :))

I would like to give you an example of what I would like to achieve as it is hard to explain :).

Due to RLS Student "A" could only see his average scores, whilst I would like him to see the average for both A and B. in this sense, how can I let a measure bypass/skip RLS

Student NameGradeTerm

A	23	1
A	32	2
A	21	3
A	22	3
B	20	3
B	19	3
B	19	2
B	21	2
B	29	2

your help is much appreciated,

Amr

[bheepatel]

Hi @Anonymous 

What if you create a new table (Table2) with a single column and row which just stores the average for both A & B?

You can then set your RLS as per usual on your first table but then you do not need to set any RLS on Table2 and you can display that average however you want.