cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Christianvs
Helper I
Helper I

Create measure to display in text box

Hi

 

I am new to Power BI so bare with me.

 

I got this table with user e-mails and names

Christianvs_0-1664135901492.png

I wish to create a text box that write the name of a user when the user is logged into Power BI with the corresponding e-mail.

For that purpose I am trying to create a measure that returns the name by using [E-mail] = USERPRINCIPALNAME() but I fail to get the measure working. 

 

Anyone who can help me out here?

Thanks

 

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@Christianvs it should be:

 

User Name Based on UPN = 
CALCULATE ( 
   MAX ( Table[Name] ),
   Table[Email] = USERPRINCIPALNAME () 
)

 

 

Follow us on LinkedIn and YouTube.gif to our YouTube channel

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

2 REPLIES 2
parry2k
Super User
Super User

@Christianvs it should be:

 

User Name Based on UPN = 
CALCULATE ( 
   MAX ( Table[Name] ),
   Table[Email] = USERPRINCIPALNAME () 
)

 

 

Follow us on LinkedIn and YouTube.gif to our YouTube channel

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Thanks parry! I needed the CALCULATE 🙂

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.