Row Level Security Comparison

[AD1588]

Hi, 

I am creating a report which is designed to be viewed by a specific (Job) level of person within the company. I have applied row level security so that this person can only view their section of the businesses data. However within the same file, I would also like to show how thats persons section is doing in comparison to the 'Rest of Estate' i.e. when user does not equal username. 

For example, 

Desktop (with full data set) will show full company sales. 

(RLS would show) Person A Sale. 

I would like to show - Person A Sales vs Everyone in the companies Sales. (This would be in the service)

Hope that makes sense. 

Please can someone advise accordingly.  

Thank you

[v-yulgu-msft · Accepted solution]

Hi @AD1588,

Suppose you have a dataset table called "Table1" that contains everyone's sales data, you could duplicate this table (achieve in Query Editor), and keep them unrelated. In report view, create two same visuals, one shows data from Table1, the other one shows data from the duplicated table. And you can apply Row Level security to the first visual, while the other one displays full company sales.

Best regards,

Yuliana Gu

[AD1588]

Thank you for your help!