Forum Discussion

laurent_rio's avatar
laurent_rio
Helper I
5 years ago
Solved

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 ...
  • Anonymous's avatar
    Anonymous
    5 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.