HELP Please: Show the Data But Not All the Details (Data Filtering Based on USERPRINCIPALNAME?)
Hello, I have a table that shows production and I would like all employees to see everyone's production but only see their own name (the rest of the names should be blank). This I have achieved using this DAX below. However, if the user logged in is a supervisor (the Employees table has a Supervisor column with a Yes or No value), there should be no filters and he/she should see all data. In the screenshot below, if Princess Leia is a supervisor, she should see all the Employee Names. Also, the supervisor may or may not have production numbers in the table. Any suggestions for how to do this? I would appreciate any help please. EmployeeName = IF( SUM('Production'[Quantity]) && SELECTEDVALUE('Employees'[LogInEmail])=USERPRINCIPALNAME(), SELECTEDVALUE('Employees'[Name]) ) Here's how it looks - Darth Vader is the user currently logged in. After I took this screenshot, I made Darth Vader a Supervisor and I want all the Employee Names to display instead of just his own name. Data tables: Employees: Production: I thought about maybe having a separate Supervisor table that contains a list of supervisors? Thanks in advance!
