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.
We have a table which includes user specific info (name, email address, location, etc.). I'd like for our reports and dashboards to show the user name and location. I have a report where I'm brought in the user info table and, of course, I can use USERPRINCIPALNAME to get the email address but is there any way to bind the USERPRINCIPALNAME to the email address in my user info table so that I can pull back the logged in user's name and location on the report/dashboard?
Here is an idea of what the shared_access table has in it:
USER NAME | USER EMAIL | USER LOCATION |
Joe Blow | Joe.Blow@gmail.com | Kansas City Office |
Sue Hue | Susan.Hue@gmail.com | Washington Office |
Patty Hatty | Patricia.Hatty@gmail.com | Buffalo Office |
Johnny Johnson | John.Johnson@gmail.com | Atlanta Office |
BZ Beez | Bertrice.Beez@gmail.com | Denver Office |
I have imported the whole table into my report.
What I want to do is something like
WHEN (USERPRINCIPALNAME = shared_access.user_email THEN show shared_access.user_location
So, if PRINCIPALNAME = Bertrice.Beez@gmail.com THEN user_location card would show Denver Office.
Solved! Go to Solution.
you could do something like this, create a measure ;
Proud to be a Super User!
That worked perfectly. Thanks so much.
you could do something like this, create a measure ;
Proud to be a Super User!
So when I try to put this in a visual, I get an error that says "A table of multiple values was supplied where a single value was expected."
can you provide some data or sample data, and then can you demonstrate exactly via dummy example of what you wanting to end up with.
Proud to be a Super User!
I'm so sorry! I updated the post to include this. I had a little trouble getting this post in (it kept not submitting it for some reason) so I had copied and pasted my message. I didn't notice that I had failed to include my sample in my copy. Thank you!
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.