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!
Detect Role at Login to Filter Items
All - I have a dashboard created in Power BI that is able to detect the user roles and shows them all the users that report up to that manager. I am trying to created a measure that will detect the users that roll up to the manager and the rest of the org. I want to see a % of my employees that passed the test and want to compare that to my peers. MEASURE = (My EMPLOYEES that passed the test/My Total Employees) - (The rest of the ORG Employees that passed the test/The rest of ORG totals) Now I want to detect my employees at login (it is easy) but I want to also detect the rest of the organizations employees to give me my measure above. Is this possible? Please let me know!! Feedback is greatly appreciated.
