Forum Discussion
Filtering table with USERNAME() for Row Level Security
Hello community, I want to have a row level security that does this "Filter the units depending on the USERPRINCIPALNAME() units when the USERPRINCIPALNAME() is in a group containing "administrati...
You don't. Apply RLS to your dimension tables and let the data model do the work for you.
Thank you for your answer.
Then, what would the DAX code look like to filter with the string "administration"?
pretty much the same as you show. Just as a RLS rule, not as a measure.
The DAX code that I wrote was written as a RLS rule and not a measure already.