Forum Discussion
Filtering table per USERNAME()
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 tha...
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
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