Little Challenge Folks

Hi Anonymous ,

According to your description, don't use selectedvalue-function which will return one single value, use values-function instead, here's my solution.

CALCULATE (
    SUMX (
        MainRawData,
        'MainRawData'[Q1] + 'MainRawData'[Q2] + 'MainRawData'[Q3] + 'MainRawData'[Q4]
    ),
    FILTER (
        MainRawData,
        'MainRawData'[Year]
            IN VALUES ( SelectedYrs[Year] )
                && 'MainRawData'[Year] <> MAX ( SelectedYrs[Year] )
    )
)

I create a sample and get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.