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 , you doing all operation with username(), how you want use with column ?

example like

// I have not tested this

Viewing As = VAR _USERNAME =CALCULATE(USERNAME()) RETURN
maxx(values(Table[User]),
RIGHT(
LEFT (
_USERNAME,
SEARCH ( "/", _USERNAME, 1, LEN ( _USERNAME ) )
),
LEN (
LEFT (
_USERNAME,
SEARCH ( "/", _USERNAME, 1, LEN (_USERNAME ) - 16 )
)
)
))

Anonymous's avatar
Anonymous
Not applicable
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