Forum Discussion
23Steve32
7 years agoFrequent Visitor
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...
23Steve32
7 years agoFrequent Visitor
Hi TeigeGao ,
Sorry if I wasn't clear, I own the dataset, I have set up some roles in the desktop which will filter different tables depending upon who is accessing the report in the service.
Basically I have a measure which will look at values from one table if the RLS filters that table other wise it should get the data from another table. I thought the ISFILTERED function would work but it doesnt seem to, so is there a way in a measure to tell if a table has been filtered by RLS?
Hope this makes sense,
Steve