Hi so I have 2 tables connected to each other through Employee ID. One is HR list of employees and second is Violations.
I have created a slicer by using employee’s name so anyone can query a particular employee and they will get count of violations of an employee.
Each employee belongs to a particular function. I want to create a measure which also tells me the number of employees in the same function who have had any kind of violations.
So for Eg - If I have selected Jamie Franco in the slicer and since he belongs to GL Global function, I should also be able to see how many employees in GL Global function had violations
Please see the attached pbix file for an example.
Query - Function.pbix (38.8 KB)