Forum Discussion
Solved
Row Level Security to be excluded from some visual
Hi, I need to implement security wherein the data should be filtered based on the user logging in: Level 1 -- Director: All Data Level 2 -- Country Head: Data for managers reporting to him + Few ...
vini_udenia I am not aware of any functionality at this point that allows RLS on toggling visual objects on the page... You would only be able to accomplish this by using variations of the report. ie, creating multiple reports.
One solution is to use USERELATIONSHIP() in a measure and have two dublicate dimensions tables, one with RLS and one without, then use USERELATIONSHIP() to change the dimension table to the one with RLS for the visuals you want filtered.
CALCULATE( Measure , USERELATIONSHIP( Data , RLS dimension))