Complex measures while comparing sales figures with switch functions

Hi mai_2020 ,

You need to use the setup following the description of SQLBI but in this case you need to make some changes to the model.

My setup is has follow:

Now I have added the following measure:

Sales Currency =
VAR DatesExchange =
    ADDCOLUMNS (
        SUMMARIZE (
            Sales,
            'Date'[Year-Month],
            'Currency'[Currency],
            "@TotalSales", SUM ( Sales[Value] )
        ),
        "@ExchangeAverageRate", CALCULATE ( SELECTEDVALUE ( Exchange[Exchange] ) )
    )
VAR Result =
    SUMX ( DatesExchange, [@TotalSales] * [@ExchangeAverageRate] )
RETURN
    Result

Result below and in attach PBIX file. Be aware that you may need to change the grouping on the summarize to fit your needs.