Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys
What I'm trying to accomplish:
In a selected month-year, for a certain employee, I need to count the shifts performed by the employee himself as well as all the shifts performed by his team in that same month-year.
Context:
An employee can work several shifts (in different skills) in a month-year, while his team works more shifts (or less).
Data:
I've got this data in a table (EMPLOYEE METRICS) that looks like this:
Employee Id - Shift Date - Shift Id - Employee Team Id
There's a relation to the Employee table, using the Employee Id column.
Using a date dimension table I'm filtering shifts by month-year.
Measure code:
If I understand correctly, you are using the Employeed_Id in the HR EMPLOYEE METRICS table and not from the HR V_EMPLOYEES, therefore there is no filter of the EMPLOYEE_ID (from the HR V_employees table) in place, due to the relationship direction between the two tables.
The current filter is now only the month-year for the whole visual, on a line-by-line basis there you also have the filter on shift_team and display_skill, depending on the level of the line.
If you use the (filtered ??) employee_id from the HR V_employees it should only show you the filtered Employee and Team
Jan
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |