Need help setting up Role using USERPRINCIPALNAME() with an extra parameter
Hello everyone! I created a Role where a Partner could only see their own Engagements by using the USERPRINCIPALNAME() measure. It is as follows: If he is a Lead Eng. Partner or and Eng. Partner or and Associate Partner, he should be able to see the Engagement he is a part of. In the following example, Partner B is an Eng Partner for the Engagement 3000431234, so he should see that row. The way I have set up, he can only see the rows his username shows up. However, in this case he would need to be able to see the other Engs. as well because one of the Engagements he is part of is in the Lead Engagement 2001401234. In cases where neither of these two conditions apply, he should not be able to see either the Eng. nor the Lead Eng. Lead Engagement Engagement Lead Eng Partner Email Eng Partner Email Associate Partner Email 2001401234 3000431234 [email protected] [email protected] n/a 2001401234 3000401555 [email protected] [email protected] n/a 2001401234 2001401234 [email protected] [email protected] n/a And that is where I'm having trouble setting up, because in some cases such as this one, the partner isn't in either of those three email fields, but because he is part of the Lead Engagement, he should also be able to see them as well. Any help is appreciated! Thanks!
(Managing Roles) Assigning Row-Level Security with Measures Is Making Visuals Go Blank
Hello all, This is my first time posting to the community, so I hope this works. I've been banging my head against my monitor trying to figure this one out. I've got a table that counts the number of employee's by their Job Title, Level and Job Family. What I'm trying to do is assign a Role that does not allow folks to see Rows that have an Employee Count of 2 or below. This could allow people to figure out salaries based off of the other visuals that express labor costs. "Employee Count" is a measure expressed by (DISTINCTCOUNT('Employee Detail'[Employee]). I'm trying to use this in my DAX formula; however, the formula is making all my visuals go blank. I've also tried this DAX expression that exclueds the measure, but still makes all my visuals blank. DISTINCTCOUNT([Employee])>"2". Can anyone offer my a solution that will allow me to create a role that will stop people seeing any rows that have an employee count of 2 or below. Thanks, Tom
