Line chart based on selected year in slicer

Hi sagarp ,

Thanks for the reply from lbendlin , please allow me to provide another insight: 

Create measure.

In_True =

SUMX ( 'Inbound', [Domestic] ) + SUMX ( 'Inbound', [Import] )

Out_True =

VAR _Store =

    SUMX (

        FILTER (

            ALL ( Outbound ),

            'Outbound'[Fiscal Year] = MAX ( 'Inbound'[Fiscal Year] )

                && 'Outbound'[Fiscal Week] = MAX ( 'Inbound'[Fiscal Week] )

        ),

        'Outbound'[Store]

    )

VAR _Wholesale =

    SUMX (

        FILTER (

            ALL ( Outbound ),

            'Outbound'[Fiscal Year] = MAX ( 'Inbound'[Fiscal Year] )

                && 'Outbound'[Fiscal Week] = MAX ( 'Inbound'[Fiscal Week] )

        ),

        'Outbound'[Wholesale]

    )

RETURN

    _Store + _Wholesale

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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