Forum Discussion

PBInewbee123's avatar
PBInewbee123
Frequent Visitor
2 years ago
Solved

How to let a visual not being affected by RLS

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

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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. 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.