Total row shows incorrect values

Hello everyone,

I have an Employee table that looks like this :

My Employee Table is not connected to my Calendar and I can't connect it because of the resulting Many to Many relationship.

In my Employee table I have the same employee numerous times in case the productity targets change (using chaning dimension table) and I have to keep a history.

When trying to calculate the total productivity target (target in that frame of time x number of business days) for a certain time frame (ex. 4 weeks using a filter) I used the following measure :

And I get the following visual :

The Test column shows the row totals and subtotals correctly but the Total row displays for the Test column 9238.5 , even though when I export the data and add them up in excel I get a Total value of 7820.2 .

Can someone please explain to me how do I get the correct Grand Total?