Getting Group/Attributes of a Filtered Item

ats1958

Here is a mock-up of what I think you are looking for.

PBIX uploaded here

This could be done a number of ways depending on your existing tables, and my mock-up could well be adapted/simplified.

1. Add an Employee Filter table, containing a single column of Employee names, with an inactive relationship to your fact table.
2. Create a measure Selected Employee Flag, which returns 1 if the currently visible Employees include those selected in the Employee Filter table (intended to be used only when filtering on individual Employees).
   

   Selected Employee Flag = 
   VAR EmployeesSelected =
       CALCULATETABLE (
           VALUES ( Data[Employee] ),
           USERELATIONSHIP ( Data[Employee], 'Employee Filter'[Employee Filter] ),
           ALL ( Data )
       )
   RETURN
       IF (
           NOT CALCULATE (
               ISEMPTY ( VALUES ( Data[Employee] ) ),
               KEEPFILTERS ( EmployeesSelected )
           ),
           1
       )

3. Create another measure Selected Employee Department Flag which returns 1 if the currently visible Departments include those of the Employees selected in the Employee Filter table.
   

   Selected Employee Department Flag = 
   VAR DepartmentSelected =
       CALCULATETABLE (
           VALUES ( Data[Department] ),
           USERELATIONSHIP ( Data[Employee], 'Employee Filter'[Employee Filter] ),
           ALL ( Data )
       )
   RETURN
       IF (
           NOT CALCULATE (
               ISEMPTY ( VALUES ( Data[Employee] ) ),
               KEEPFILTERS ( DepartmentSelected )
           ),
           1
       )

   
   
4. Create your visual (at an Employee level of detail), and add a Visual Level Filter "Selected Employee Department=1"
5. Put the Selected Employee Flag in Color Saturation, and tweak colours as needed.
6. If multiple Employees are selected, they will all be highlighted with relevant Departments shown.

Regards,

Owen