Forum Discussion
RLS Security with External Customers (Dynamic) with also conglomerated data?
Hello BugmanJ ,
you can create a RLS table like customerid, companyname, domain.
and you can create relationship to table like Customers. after that anyone signing in with abc.com only sees rows where Customers[Domain]=abc.com
For second question, RLS blocks all non matching rows so average(deliverytime) will only show the current customer's average. To show all customers average time, you should use all(customers) in your calculate.
BugmanJ , Couple of ways.
1. Create a table that has all the needed dimensions, like date, etc., but no customer-related columns, and do not join with the customer dimension joining with RLS . This will dynamically act to all or all selected in your measure as per need
2. Have a static column in the fact Average(Table[Time]) , this will static avg after every load
anilelmastasi wrote:For second question, RLS blocks all non matching rows so average(deliverytime) will only show the current customer's average. To show all customers average time, you should use all(customers) in your calculate.
But this is where i struggle, if I am using RLS, this automatically removes rows before the ALL customers can be calculated if I read how this works correctly?
Idrissshatila wrote:As for question 2, i didn't understand it, can you explain your point of view.
Okay in my data I have say 5 customers so the average is of the 5 customers time and on my graph, i want to show this line PLUS i want to show just a single customers line. How can I do it so that the averaged 5 customers line is shown as awell as the specific customer line? I believe if i use RLS, this will automatically exclude the other customer lines even if i use ALL in the line?
anilelmastasi / Idrissshatila
BugmanJ , Couple of ways.
1. Create a table that has all the needed dimensions, like date, etc., but no customer-related columns, and do not join with the customer dimension joining with RLS . This will dynamically act to all or all selected in your measure as per need
2. Have a static column in the fact Average(Table[Time]) , this will static avg after every load