Semi-Additive Calculations - Total Values wrong

Hi, 

here is what i am trying to accomplish:

Target:

Building a Liquidity Report, showing for each business area / company / account the values: Closing Balance, Overdraft, Liquidity, week-over-week change in one single reporting currency

Obstacle:

Balances of accounts are reported for different dates.

Missing exchange rates for reported dates

Solution approach:

For the exchange rates i used the conversion with a calculated column, finding the last available exchange rate, which seems to work fine

For the account balances i tried to use the DAX Pattern - Semi-additive calculations:

+ Finding last available value for each account

+ Finding opening & closing balance

+ Finding Change between two calendar weeks

Problem:

Finding those values for the above mentioned columns worked well, however, on the total level there are values i cannot explain. 

Measures:

For example i calculated the overdraft by this measure (the others follow the same logic):

Overdraft Latest =
VAR MaxDate = MAX('Date'[Date])

VAR MaxDates = CALCULATETABLE(
                               ADDCOLUMNS(
                               SUMMARIZE(FactBankBalances, FactBankBalances[IBAN]),
                              "@MaxDate", CALCULATE(MAX(FactBankBalances[DateKey]))
                              ),
                              'Date'[Date] <= MaxDate
)
VAR MaxDatesWithLineage =
                           TREATAS(MaxDates, FactBankBalances[IBAN], 'Date'[Date])

VAR Overdraft = CALCULATE(AVERAGE(FactBankBalances[KK_Linie_Euro]), MaxDatesWithLineage)

VAR Result = CALCULATE(
                                           DIVIDE(Overdraft,
                                           SELECTEDVALUE(ReportNumberFormat[SelectedDivision]),
                                           1)
                                            )

Return
      Result

The Data Model:

The matrix report:

With the wrong calculations at the total level.

Thankful for any clue 😉

Bruin87