Hi Melissa,
Thanks. It already solve 90% of the problem.
I apply you recommendation in my model and it can limit the data access for each user .
Actual, there is no relationship between region and sales person and they came from 2 different data sources, but i may create a table for all combination of region and sales person.
But how can I keep to use DIM-Customer as filter table (slicers in report) as it get more customer information that exclude in User control table?
As I cannot build active relationship between User Control table and DIM-Customers table, and user can see all RSO value in the slicer even though they cannot view the data
(Steven should able to see DACH, NL, PL only).
I would like the user login to Power BI and review their own region data without any further selection.
I upload my model and all sensitive data has been corrected. Thanks.
Demo.pbix (1.2 MB)
EU-DATA-DIM.xlsx (198.3 KB) EU-DATA-FACT.xlsx (1.7 MB)RLS control-add sales person.xlsx (18.2 KB)