This statement not correct.
My understating of the problem is that for the same Req ID I get many possibilities for some fields. For example because in the same Req ID I have one raw data showing Management as Assignment and one other raw showing Worker as Assignment when I try split the view by Assignment then it is counting the same Req ID two times.
Because you are calculating "Max" for different group , those never match.
ie) sum of Max of ID = 50 + 30 + 200 + 300
Max of Management = 300 + 30
Max of worker = 50 + 30 + 200 + 300
I don't understand What "Max" represents in this case and what do you want to calculate with "Max"....
If I put "sum" instead, and remove "Fix", everything looks clean with total 1740..
LOD_rep_9.1.twbx 53.0 KB
The issue is that ReqID=4 and ReqID=2 are spread across onshore and offshore.
What LOD calc does is to compute the Max for each ReqID and joins it back to the main table.
So the same value will appear for both onshore and offshore since there is a ReqID matching both.
The question is what should each metric show when you toggle settings. It is correct that Max Value for that ReqID is that value. If you split the value in half to get the double count than the bar chart would be incorrect.