Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

Filtering table per USERNAME()

Not knowing DAX at all but know excel so struggling to learn how things are done,

I have a table with many users data and wish to filter it per user,

I have a table user mapping that has the email addesses [Username] and names [Name]

i've created a measure that returns the username from their loggin

Userfilter =

LOOKUPVALUE(Usermapping[Name],Usermapping[Username],USERNAME())

This works fine and i can have a card that returns the name of the user,

But how can i filter a column on based on this measure

I tried a new column with

User List =

IF('PDM Output'[Assignee]=Usermapping[Userfilter],'PDM Output'[Assignee],BLANK())

But it errors with the username function is not supported, seems like a real simple problem but hard to solve in power bi, please help

Anonymous
3 years ago
I've solved it by using the the roles and permissions that only shows the usernames that are the same as USERNAME(), Usernames is only used in the one table that i want to filter so all other data is ok

Greg_Deckler
Community Champion
3 years ago
Anonymous Correct, USERNAME is not supported in calculated columns but rather only in measures. So, use a measure instead that returns a 1 or 0 and in your Filters pane filter the measure to only be 1 or 0. The Complex Selector - Microsoft Power BI Community
- Anonymous
  Not applicable
  3 years ago
  I've solved it by using the the roles and permissions that only shows the usernames that are the same as USERNAME(), Usernames is only used in the one table that i want to filter so all other data is ok
Anonymous
Not applicable
3 years ago
Thanks could you make that a bit simplier for me i'm a bit fried on this at the moment, The User filter returns at the moment a single value but in the 'PDM Output'[Assignee] column i have returns many rows of the user, can't see how i can do this without creating a column that is linked to the Username to flag it as 0 or 1