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.
Suppose this is my table called "People"
I want to set up a role that says "You can only see data about other people from the same country as yours".
Is there not a simple DAX for this?
[Country] = <the same>
Solved! Go to Solution.
You would need to use something like LOOKUPVALUE(...) = [Country] where your LOOKUPVALUE would use the Name to lookup the user's country.
@Anonymous
You may refer to the following post.
You would need to use something like LOOKUPVALUE(...) = [Country] where your LOOKUPVALUE would use the Name to lookup the user's country.
The report has email and uses USERPRINCIPAL() extensively. Does that make it easier?
@Anonymous
You may refer to the following post.
You would need to use something like LOOKUPVALUE(...) = [Country] where your LOOKUPVALUE would use the Name to lookup the user's country.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |