Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
@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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |