Forum Discussion
PRLS with lookupvalue on 2 tables different
I have a table A I have a dimension table A containing the names and emails of managers and teams, I have a table made B with all the appropriate calculations. The problem is that when I implement the RLS, it finds all the team data, not the manager's data, but now I can't add the manager to the final data. Here is the code I used but it's not good.
IF (
ISFILTERED ( 'A'[NAMES_TEAM] ),
'A'[NAMES_TEAM] = USERNAME() || 'A'[MAIL] = USERPRINCIPALNAME(),
'A'[MAIL] = USERPRINCIPALNAME() && 'B'[TEAM] = LOOKUPVALUE('A'[TEAM],'B'[MAIL],USERPRINCIPALNAME())
)
2 Replies
- Mahesh0016
Super User
huguo_90 Please Share your Expected Output in Table.
THANK YOU!! Hello Mahesh0016 , Thanks to answer me, When I make a filter on the size table I only see the people of the Pierre team but I do not see see Pierre so in the dashbord I do not see his income, I would like to see the revenues of Pierre and his are teams, I try by putting a double relationship on it but it does not work. Hope you manage to understand my drawing.
