Sum Values in Matrix based in another value in that matrix

Hey MRoth ,

despite my last questions from a little earlier, I think this measure is doing the trick regarding the Forcasted Value:

tom forecasted value = 
// offset value
var currentOffset = SELECTEDVALUE( 'Offset'[Parameter] )
return
CALCULATE(
    sum( 'Forecasts'[Forecasted Value] ),
    OFFSET(
        CurrentOffset * -1,
        SUMMARIZE(ALLSELECTED('Forecasts'), 'Dim Forecasts'[ForecastVersion], 'Forecasts'[ForcastWeek]),
        ORDERBY('Forecasts'[ForcastWeek]),
        KEEP,
        PARTITIONBY('Dim Forecasts'[ForecastVersion])
    )
)

Please be aware that I changed the data type of Forecasts[ForecastsWeek] to "whole number"; otherwise, the ORDERBY clause in the OFFSET function will order the weeks alphabetically.

At least the results look reasonable 😉

Hopefully, this helps to tackle your challenge.

Regards,
Tom