Forum Discussion

Rjesak's avatar
Rjesak
Helper 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] ))
Rjesak's avatar
Rjesak
Helper I
5 years ago

That worked perfectly. Thanks so much.