Filtering table per USERNAME()

[charles88]

Hi 

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

[charles88]

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 

[Greg_Deckler]

@charles88 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

[charles88 · Accepted solution]

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