show aggregate peer data in RLS

[Anonymous]

Hi,

In the report, I am comparing client and it's peer group data for few attributes. This report is RLS enabled, so the users can see only those records for which they have access.

But the requirement is that users should see those records for which have the access and also want to see the aggregated data for remainig records. these aggregated records are required as this report shows the comparison of a selected client with rest of its peer group.

User	Client	Product	Ranking
A	ABC	X	3
B	BAC	X	2
E	CAB	X	6
A	BCA	Y	2
D	CBA	Y	4
E	ACB	Y	2

By considering the above sample data, If user A logins in the report and want to compare the rank of product X for client ABC then it should show rank of product X for client ABC and compare it with the average of ranking for rest of the clients (BAC, CAB) for same product X. 

As RLS implemented, so user A can see the records only for ABC and BCA clients but the requirement is User A should be able to see aggregated data (no other details like client, product details) also for the clients for which it doesn't have the access. 

Please suggest if there is any way possible to achieve this.

Thanks

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

I think that should not be achieved. As if the RLS is applied, you cannot get the data without permission.

It is recommended that you create a separate summary report, without RLS configured in the summary table, and give the user access rights. 

Similar question refer:

https://community.powerbi.com/t5/Desktop/Roles-Row-Level-Security-and-Aggregated-Data/m-p/638280 

https://community.powerbi.com/t5/Desktop/Aggregated-Measures-with-RLS/m-p/101813

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien