How to let a visual not being affected by RLS

[PBInewbee123]

Hi,

I am creating a dashboard where I want to show parent materials, with all their child materials (mat nr, qty, ...). I also want to show the nr of pieces on stock at the central warehouse, but also locally.

This means that a certain location should see all child materials, whether or not they have local stock of that child material, but only their own stock and not that of any other location (except for the central warehouse).

This is part of a much bigger report, for which RLS is set up, based on the location of the users.

Issue that I am having now is that from the moment a user wants to check this, they only see the child materials that are on their stock, and not the others anymore, due to the RLS. Any idea how to solve this?

I thought about creating 2 visuals: 1 showing all information except local stock level, and a second one, showing only the child material and the stock level, but also then, the RLS will filter the first visual. Any ideas?

Thanks

[v-tangjie-msft · Accepted solution]

Hi @PBInewbee123 ,

Thanks @amitchandak  for the quick reply and solution. Here are some of my additions.

1.This is my test data.

2.We can create a table.

Table 2 = SUMMARIZE('Table','Table'[user],"Remaining stock",CALCULATE(SUM('Table'[stock]),ALL('Table'))-SUM('Table'[stock]))

3.We can create RLS.

4.Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[amitchandak]

@PBInewbee123 , You need to have a table (may be aggregated), where the RLS filter does not apply.