Bug Fix: Resource missing from Slicer when filtering Department

Display table of contents

PowerBI Changes >

Bug Fix: Resource missing from Slicer when filtering Department

While slicing by resource's current Department the Resource Utilization report would filter out forecasted demand hours planned across Departments other than the selected department/s.  This bug been fixed by replacing the Resources[Department] with the ResourcePlan[Department].  As a result, it was necessary to create a new _ResourcePlanCapacity measure which takes the new context of Date, ResourcePlanResourceID and ResourcePlanDepartmentID into account.