Forum Discussion
laurent_rio
5 years agoHelper I
How to lock measure not affected by RLS ???
Hi i have chart that show total employee number and training hours per department. On the dashboard also will show average company training hours/staff ( total training hours for whole company/total ...
- Anonymous5 years ago
Hi laurent_rio ,
Based on my test, the RLS filter the dataset directly. ALL() and ALLSELECTED() are unlikely to work in this case.
So my workround is to create a new column/table for the average calculation that could not be affected by RLS
Avg Column = AVERAGEA('Table'[Training Hours])Table 2 = SUMMARIZE('Table',"Avg of All",AVERAGE('Table'[Training Hours]))The final output is shown below:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
laurent_rio
5 years agoHelper I
Hi amitchandak
Thanks for you reply both looks not really straight forward but i will look into it first
Thanks