Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
My RLS is set up to return the Manager of the user and all employees under that Manager (this allows user to see how they stack up to others under same team)
pathcontains(tEmployees[Employee path],
Maxx(
filter(
tEmployees,
tEmployees[Email]= USERPRINCIPALNAME()), tEmployees[Manager]))
**My slicer is working fine for this, it shows Employee, their Manager and their reports. This page shows metrics/no details.
I want to show a different slicer on a different page for the User and his reports (not show the one level up Manager detail)
If I could create this in a measure and display it in a slicer, that would be perfect... but it's not working.
pathcontains(tEmployees[Employee path],
Maxx(
filter(
tEmployees,
tEmployees[Email]= USERPRINCIPALNAME()), tEmployees[UserId]))
I thought if I could get the USERPRINCIPALNAME() and compare to the rows, then it would work... but I must not be doing it right.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
28 | |
26 | |
22 | |
22 | |
18 |
User | Count |
---|---|
52 | |
34 | |
28 | |
24 | |
21 |