topic Different row level security in different table but same report in DAX Commands and Tips

Different row level security in different table but same report

Dimitris_Kats — Mon, 20 Jun 2022 12:21:09 GMT

Dear members hi,

I have a problem that I really don't know how to solve it.
I have a report with row level security based on division. For example the Sales Manager will be able to see in detail only the Sales Division. For example he will be able to see the cost per employee for the sales division. But i need in the same report in different table to be able to see the total average cost for all divisions. He won't be able to see anything else except the total average.

Is this possible??

Thank you in advance

Re: Different row level security in different table but same report

amitchandak — Mon, 20 Jun 2022 13:50:28 GMT

Dimitris_Kats , You can have separate table with global avg, where RLS is not applied

Re: Different row level security in different table but same report

Dimitris_Kats — Mon, 20 Jun 2022 14:00:33 GMT

Yessssss amitchandak

Very clever!!

Thank you very much!!!