Forum Discussion
RLS not working on Measures
Hi,
I am creating a dashboard that will be used to view departmental Budgets/Forecasts and Actuals. I need to be able to implement RLS so that when each department head opens the report the data will be filtered to their specific budget/forecast/actual spend.
I have 3 fact tables: budget/forecast/overheads
I have several dimension tables: Company, Date, GL Details, Business Area (contains employee name, department, budget refs), Budget Owner (contains employee name and email address)
I have managed to create the RLS so that it filters the page to each department head e.g. Department = "IT". This enables them to see their individual budget/forecast, but when it comes to the measures I have created, YTD Actuals, Budget Variance and Forecast Variance, its not taking into consideration the RLS and is just showing the calculation for all departments.
Is there something that I need to add into the measures to make sure it filters based on the RLS?
Thanks,
Helen
- Anonymous3 years ago
Hi HSymes-Thompson,
RLS effects are applied from table relationships, please check the relationship mapping and direction of your tables to confirm if the relationship are setting the single direction.
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng
1 Reply
- AnonymousNot applicable
Hi HSymes-Thompson,
RLS effects are applied from table relationships, please check the relationship mapping and direction of your tables to confirm if the relationship are setting the single direction.
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng