Matrix Visual Incorrect Total

[skvf1]

Hi there

I am totally stumped in the below scenario.

1. This is a visual showing various calculations (hours) for a domain "BA_COE". A calculation the total missing timesheets (hours) are 416 hrs (for July only)

2. I am trying to drill down the BA_COE that which employees actually involved in missing timesheets (using matrix visual) which logically should show total = 416 hours too. But I am getting below and total = 400 hours

3. The differentiating factor is the 1st employee Ashishkumar having -16 hours. If this become +16, the total would be 416 (as above).
4. I am using the same measures and values for both visuals but the results are different. For "2", I am applying the filter of "BA_COE" only

When I am selecting a different domain, let's say "Testing_Release", the same measure and values, both visuals showing the same total.

Measures used:
Missing Timesheet = [WorkingHours]-(sum(CATS[Number (unit)]))

Any expert can help me please here how to get the correct total of 416 in "2". Will be very much thankful.

Thanks

 

[Matt Allington]

What is the working hours measure?