Forum Discussion
Divide RLS restricted number by total unrestricted number
Hi,
I have a table as such
Department | Sales |
A | 50000 |
B | 25000 |
C | 25000 |
When person A logs in using RLS (Department = "A"), he can only see his 50k. But I want a scorecard visual that divides his sales by the total in the organizaton. 50k / 100k = 50 %.
Is this possible?
Anonymous - So how I have handled this in the past is to create an "aggregation" table where these numbers are stored that is disconnected from RLS. Then users and DAX have access to these numbers. So, you could create a new table like:
Table = { Aggregates }
Then add a column to this table:
Total Sales = SUMX('Table1',[Sales])
1 Reply
Anonymous - So how I have handled this in the past is to create an "aggregation" table where these numbers are stored that is disconnected from RLS. Then users and DAX have access to these numbers. So, you could create a new table like:
Table = { Aggregates }
Then add a column to this table:
Total Sales = SUMX('Table1',[Sales])