Multi currency reporting question

Hi chutchut09 ,

I suggest you to create an unrelated Currency Code table for slicer.

Sales Currency =
IF (
    MAX ( 'Dim Currency'[Currency Code] )
        IN VALUES ( 'Slicer Currency'[Currency Code] ),
    IF (
        ISFILTERED ( 'Slicer Currency'[Currency Code] ),
        IF (
            ISCROSSFILTERED ( 'Dim Currency' ),
            VAR SelectedCurrency =
                SELECTEDVALUE ( 'Dim Currency'[Currency Code], "USD" )
            VAR DatesExchange =
                SUMMARIZE (
                    FILTER (
                        'Fact Exchange Rate',
                        'Fact Exchange Rate'[Reporting Currency] = "USD"
                    ),
                    'Fact Exchange Rate'[MMM-YYYY],
                    'Fact Exchange Rate'[Exchange Rate]
                )
            VAR Result =
                IF (
                    NOT ISBLANK ( SelectedCurrency ),
                    IF (
                        SelectedCurrency = "USD",
                        [Total Sales_USD],
                        SUMX ( DatesExchange, [Total Sales_USD] * 'Fact Exchange Rate'[Exchange Rate] )
                    )
                )
            RETURN
                Result
        ),
        [Total Sales_USD]
    )
)

Result is as below.

Best Regards,
Rico Zhou

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