Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |