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
SELECTEDVALUE doesn’t work well with RLS unless a slicer is used. Instead,
use:
OutputName_RLS = CALCULATE(MAX('Mapping (SE)'[OutputName]))
This grabs the RLS-filtered value directly, even without manual selection.
I cannot use min or max in measure becoz i have bith +ve and -ve values , so is there any other way to use this in a right way