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
Hi BugmanJ,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to amitchandak, anilelmastasi, Idrissshatila, for those inputs on this thread.
Has your issue been resolved? If the response provided by the community member amitchandak, anilelmastasi, Idrissshatila, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.
Hi BugmanJ,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.Thank you.