Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Request your help on this :
We have a table containing emailids of some people outside our orgainization and also within our organization.The requirement is that when these people log on they are going to see all the detail only of their organizations(all data related to them as well as of others who belong to same organization).
Please can you help me with the dax expression .
I tried applying a filter on organization name column in manage roles in power bi desktop but this not at all working:
LOOKUPVALUE([Organization Name],Emailid,USERNAME())
My objective is to pick up organization name if the emailid of the person logged on is there in emailid column.
Thnaks,
Saranee
Solved! Go to Solution.
The following DAX filter expression works for me. You might also need to check the relationship.
[Organization Name] = LOOKUPVALUE(Table1[Organization Name],Table1[Emailid],USERPRINCIPALNAME())
The following DAX filter expression works for me. You might also need to check the relationship.
[Organization Name] = LOOKUPVALUE(Table1[Organization Name],Table1[Emailid],USERPRINCIPALNAME())
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |