Forum Discussion
USERNAME() function DAX
Hi,
I am trying to use Row Level Security for my Power Bi model and for that I am using username() function to get the filters. The thing is that I have two filters to pass and thus would like my username() function to be able to take 2 values. Is there any way of doing it ?
Not quite sure if this is what you're looking for, but I do something similar using LOOKUPVALUE. Basically I find where USERNAME() matches the Email in the Users table and then filter the Programs table where either the returned Program 1 or Program 2 match. The filters on the Programs table then flow to all the other tables in my model.
Programs
Program
Users
User 1 Email Program 1 Program 2
My RLS set up in the Programs table is:
[Program] = LOOKUPVALUE(Users[Program 1], [Email], USERNAME()) || [Program] = LOOKUPVALUE(Users[Program 2], [Email], USERNAME())
4 Replies
Not quite sure if this is what you're looking for, but I do something similar using LOOKUPVALUE. Basically I find where USERNAME() matches the Email in the Users table and then filter the Programs table where either the returned Program 1 or Program 2 match. The filters on the Programs table then flow to all the other tables in my model.
Programs
Program
Users
User 1 Email Program 1 Program 2
My RLS set up in the Programs table is:
[Program] = LOOKUPVALUE(Users[Program 1], [Email], USERNAME()) || [Program] = LOOKUPVALUE(Users[Program 2], [Email], USERNAME())
Thanks that worked perfectly.
This solution works perfectly but I was confused on the second part "The filters on the Programs table then flow to all the other tables in my model"
I am trying to filter other tables with no user info in them but has relation to programs. And I try to filter other table based on the programs table I am not able to filter that.
This solution works perfectly but I was confused on the second part "The filters on the Programs table then flow to all the other tables in my model"
I am trying to filter other tables with no user info in them but has relation to programs. And I try to filter other table based on the programs table I am not able to filter that.
