Forum Discussion

23Steve32's avatar
23Steve32
Frequent Visitor
7 years ago
Solved

Is there a way to tell if RLS is filtering a table using dax

As the subject says, I would like to know if a table has been filtered via RLS - it doesnt look like ISFILTERED picks up on RLS filtering. Is this possible and if so how?    Thanks in advance, Ste...
Need Help
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    Hi 23Steve32 ,

    As I mentioned above, we can't create a measure to judge if the data has been filtered, RLS is applied at the dataset level, the measure is created inside the dataset. For objects inside the dataset, it is just the "full" dataset.

    Best Regards,

    Teige

cnonline's avatar
cnonline
Regular Visitor
3 years ago

Try creating a simple count measure to RLS table if your using dynamic RLS. But I guess this will work for the usual RLS scenario as well. (RLS is my bridging table) This worked for me!

 

RLS Count = DISTINCTCOUNT(RLS[UNAME])

 

And then I created an another switch measure to change a simple icon image in the report. You can do anything with in switch.

 

RLS Secuity check = SWITCH(
    TRUE(),
    [RLS Count]<=1,"Image link to identify RLS applied", 
    [RLS Count]>1,"Image link to identify RLS not applied", 
    "Default image link"
)