Divide RLS restricted number by total unrestricted number

[Anonymous]

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? 

[Greg_Deckler · Accepted solution]

@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])