Forum Discussion

Rjesak's avatar
Rjesak
Icon for Helper I rankHelper I
5 years ago
Solved

Display User Information on reports/dashboards

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 ...
Need Help
  • vanessafvg's avatar
    vanessafvg
    5 years ago

    you could do something like this, create a measure ;

     

    User Location=
    var curruser = USERPRINCIPALNAME()
    return
    CALCULATE(VALUES(shared_access[USER LOCATION]), FILTER(shared_access, curruser = shared_access[USER EMAIL] ))
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
5 years ago

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.

 

 

  • Rjesak's avatar
    Rjesak
    Icon for Helper I rankHelper I
    5 years ago

    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!