Forum Discussion
When running RLS, page data is not completely filtered, just some visuals. And when doing this same
Hey, Daniel29195 e Anonymous!
I managed to solve the problem. In fact, my original measurement had some conditions. It was like this:Goal 1 - % Achieved - C2024 =
VAR _DaniloPEA =
CALCULATE(
[A+ Companies - PE - C2024],
dFuncionario[Email] = "email.com"
)VAR _DaniloRA =
CALCULATE(
[Goal 1 - A+ Meetings - C2024],
dFuncionario[Email] = "email.com"
)
VAR _EquipePEA =
CALCULATE(
[A+ Companies - PE - C2024],
ALL(dEmployee[Name], dEmployee[Email]),
dFuncionario[E-mail Coordinator] = "email.com"
)VAR _EquipeRA =
CALCULATE(
[Goal 1 - A+ Meetings - C2024],
ALL(dEmployee[Name], dEmployee[Email]),
dFuncionario[E-mail Coordinator] = "email.com"
)VAR _Result =
IF(
SELECTEDVALUE(dEmployee[Email]) = "email.com",
DIVIDE(
_EquipeRA - _DaniloRA,
_EquipePEA - _DaniloPEA
),
DIVIDE(
[1st Meetings - C2024],
[PE Companies - C2024],
0
)
)RETURN
_ResultSo for some reason when I used RLS, the filter didn't reach some visuals. To solve the problem, I adapted the measurement and it looked like this:
Goal 1 - % Achieved - C2024 =
CALCULATE(
DIVIDE([1st Meetings - C2024], [PE Companies - C2024]),
dEmployee
)I used CALCULATE to force the filter on the "dFuncionario" table, and in the end everything worked fine.
Thank you very much for the time you took to help me. Thank you so!
Hi Daniel!
I watched your selection. In the video he refers to RLS coming from the source, which is not my case. In my case, I create the RLS using an "employee" dimension that I developed manually to bridge the DirectQuery table.
Using this "employee" dimension in the data segmenter, the page is filtered perfectly, but when I do the same filter in RLS, only some visuals are filtered, the others remain without obeying the filter. 😔
Hi Daniel29195 , thanks for the quick reply.
Hi franciscocruz ,
Regarding your question, you mentioned that you created a security information table 'employee'.
1. RLS filters are only propagated through activity relationships, make sure there is a correct one-to-many relationship between the dimension table and the fact table.
2. If there is no problem with the model relationship, ensure that the correct UPN is stored in the security information table, then you can try reconfiguring RLS.
3. Check the official documentation of your data source to see if RLS is supported.For more information, please refer to the following articles:
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hey, Daniel29195 e Anonymous!
I managed to solve the problem. In fact, my original measurement had some conditions. It was like this:Goal 1 - % Achieved - C2024 =
VAR _DaniloPEA =
CALCULATE(
[A+ Companies - PE - C2024],
dFuncionario[Email] = "email.com"
)VAR _DaniloRA =
CALCULATE(
[Goal 1 - A+ Meetings - C2024],
dFuncionario[Email] = "email.com"
)
VAR _EquipePEA =
CALCULATE(
[A+ Companies - PE - C2024],
ALL(dEmployee[Name], dEmployee[Email]),
dFuncionario[E-mail Coordinator] = "email.com"
)VAR _EquipeRA =
CALCULATE(
[Goal 1 - A+ Meetings - C2024],
ALL(dEmployee[Name], dEmployee[Email]),
dFuncionario[E-mail Coordinator] = "email.com"
)VAR _Result =
IF(
SELECTEDVALUE(dEmployee[Email]) = "email.com",
DIVIDE(
_EquipeRA - _DaniloRA,
_EquipePEA - _DaniloPEA
),
DIVIDE(
[1st Meetings - C2024],
[PE Companies - C2024],
0
)
)RETURN
_ResultSo for some reason when I used RLS, the filter didn't reach some visuals. To solve the problem, I adapted the measurement and it looked like this:
Goal 1 - % Achieved - C2024 =
CALCULATE(
DIVIDE([1st Meetings - C2024], [PE Companies - C2024]),
dEmployee
)I used CALCULATE to force the filter on the "dFuncionario" table, and in the end everything worked fine.
Thank you very much for the time you took to help me. Thank you so!