Forum Discussion

ribisht17's avatar
ribisht17
Icon for Super User rankSuper User
4 years ago

Anonymous 

 

USERNAME /USERPRINCIPAL will always have the user name of the person logged in.

I don't think this can be handled by DAX.

There is a possibility for an Admin to switch over to other roles (as you can do in Tableau) but not with this Table approach

 

Regards,

Ritesh

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Ritesh,

     

    I think I understand what you're saying, let me ask this...  Is it possible to filter a table by correlating the userprincialname to a value in the table?  So for instance I have this measure:

    actingsupervisor = IF(
         CALCULATE(
              HASONEVALUE(FTEs[name of supervisor]), ALLSELECTED(FTEs[employee])) = TRUE(),1,2)

     

    I then put this measure as a filter on the visual and use it to show items when the value is 1.  This will allow me to display only the employees related to that supervisor in the visual that his this filter.  So is it possible to replace the 'FTEs[name of supervisor]' of the measure above with something like userprincipalname()?