.

Hi Anonymous ,

 

We can use the following measure to meet your requirement.

 

 

 

Measure =
VAR y =
    MIN ( 'Table'[Fiscal Year] )
RETURN
    SUMX (
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[ForecastName] IN DISTINCT ( 'Table'[ForecastName] )
        ),
        VAR d = [Fiscal Year] - y
        RETURN
            IF ( d <= 1 && d >= 0, [Value], IF ( d = 2, 0.5 * [Value] ) )
)

 

 

 

 

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

 

BTW, pbix as attached.

Best regards,