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] )
                    )
                )
            )
        )
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

I only created the sales amount, and I hope you can apply the same logic to Cost and Profit as well.

  • 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!