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

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
    Icon for Helper I rankHelper I
    5 years ago

    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."