Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Username() function as a filter

  I want to achieve this function.   I have a user name column, whenever the user logs in to pbi only his name should be filtered and all other things should show up based on his username alone. ...
Need Help DAX
Need Help DAX measure
  • Anonymous's avatar
    Anonymous
    5 years ago

    I have edited the main message, can you please check and respond accordingly. All tht I am looking for is to be able to check whether the username() returning value and the column value in my table are matching using a calculated column, so that I can add the TRUE value as a page level filter. Hope you got my situation. amitchandak 

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , both username, and userprincipalname can not be used in the column.

 

Not you can use Functions like Sumx, Countx etc. If needed use values(Table[ID]) // some root level column you can use force this calculation at a lower level.

Sumx(Values(Table[ID]), <Formula>)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak thanks for the response, can you please elaborate on how sumx or countx could be used in my case. I am unable to understand 

thanks