Dynamic sales based on slicer

Hi King8James ,

Please try:

new sales =
VAR sce =
    SELECTEDVALUE ( forecast[Alternative] )
VAR _a =
    CALCULATE (
        SUM ( 'Table'[Sales] ),
        FILTER ( 'Table', 'Table'[Alternative] = sce || 'Table'[Alternative] = "FIX" )
    )
VAR _d =
    CALCULATE (
        MIN ( 'Table'[Month] ),
        FILTER ( ALL ( 'Table' ), [Alternative] = sce )
    )
RETURN
    IF (
        MONTH ( MAX ( 'Table'[Month] ) ) >= MONTH ( _d )
            && MAX ( 'Table'[Alternative] ) = "FIX",
        BLANK (),
        _a
    )

Final output:

Best Regards,

Jianbo Li

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