Forum Discussion
Solved
RLS not working fine while using selected value in measure
I'm using RLS on the [OutputName] column (e.g., 'Mapping (SE)'[OutputName] = "B&FCommon"), and while the data is incorrectly filtered, my measure using SELECTEDVALUE('Mapping (SE)'[OutputName]) give ...
Hi everyone,
I’ve found the solution to this issue. When we use the SELECTEDVALUE function in a measure, it doesn’t return the correct result under RLS, since RLS only filters rows and doesn’t actually make a selection.
To fix this, I used the HASONEVALUE function instead, which works correctly for all users and ensures that RLS returns accurate results.
Thanks
OutputName_RLS =
CALCULATE(
FIRSTNONBLANK('Mapping (SE)'[OutputName], 1)
)
I tried this ,it is filtering right cost center but value of measure is wrong only coming true by selecting manually.