Forum Discussion

Dimitris_Kats's avatar
Dimitris_Kats
Icon for Helper V rankHelper V
4 years ago
Solved

Fixed Exchange Rate

Hello Everyone,   I have a small problem...i can think of a solution but I am not sure if its the best one so I will need your advice about that.   I have a table with sales, cost and profit per ...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I tried to create it in the next page in the attached pbix file.

    please check the below picture and the attached pbix file.

     

     

    Sales currency slicer: =
SWITCH (
    SELECTEDVALUE ( 'Currency Select'[Currency select] ),
    "Local", IF ( HASONEVALUE ( Sales[Country] ), SUM ( Sales[Sales (Local Currency)] ) ),
    "Euro",
        SUMX (
            sales,
            CALCULATE (
                DIVIDE (
                    SUM ( Sales[Sales (Local Currency)] ),
                    LOOKUPVALUE (
                        ExchangeRate[Exchange Rate],
                        ExchangeRate[Country], SELECTEDVALUE ( Sales[Country] )
                    )
                )
            )
        )
)
Dimitris_Kats's avatar
Dimitris_Kats
Icon for Helper V rankHelper V
4 years ago

First of all thank you very much for your reply! I appreciate it!!

To be honest i wanted to have only 2 selections on the currency slicer : Local and euro.
If they select local currency they will see the sales exactly in the way I have them in the sales table. If they select euro they will have the sales in euro based on the exchange rates on the second table.
Do you think this is possible?

Thank you very much again for your time and help!

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

I tried to create it in the next page in the attached pbix file.

please check the below picture and the attached pbix file.

 

 

Sales currency slicer: =
SWITCH (
    SELECTEDVALUE ( 'Currency Select'[Currency select] ),
    "Local", IF ( HASONEVALUE ( Sales[Country] ), SUM ( Sales[Sales (Local Currency)] ) ),
    "Euro",
        SUMX (
            sales,
            CALCULATE (
                DIVIDE (
                    SUM ( Sales[Sales (Local Currency)] ),
                    LOOKUPVALUE (
                        ExchangeRate[Exchange Rate],
                        ExchangeRate[Country], SELECTEDVALUE ( Sales[Country] )
                    )
                )
            )
        )
)
  • Dimitris_Kats's avatar
    Dimitris_Kats
    Icon for Helper V rankHelper V
    4 years ago

    That's amazing and exactly what i need! 
    Thank you so much!