Forum Discussion
Row Level security - Show report user which RLS role filters the report
Hi. I have a report that requires the use of RLS. Different RLS groups are assigned to the report. E.g I have these roles: EU <- Only data for EU countries US <- Only data for US Bicycle:...
Anonymous
You could use a measure over the column that is being filtered by RLS to show them the selection of items they can see. Assuming there is a column in your table call [Region] and that is where you are applying the filter, a measure like this will show them the region.
Regions = "Viewing data for: " & CONCATENATEX(VALUES('Table'[Region]),'Table'[Region],",")