Forum Discussion

mmazzalay's avatar
mmazzalay
Frequent Visitor
7 years ago
Solved

Filter by currency

Hey there I created a report in which the user can select currency to see the data. To solve this, I have a table like this: Date               Sales     Currency 01/01/2019    10000   ARS 01/01/...
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi  mmazzalay ,

     

    You can create a new table named Currency like below:

    CurrencyName

    Rate

    USD

    1

    ARS

    45.05

     

    Assuming to take US dollar as the basic currency rate, let the [CurrencyName] in Currency as the source of Slicer visual. Then you can create a new measure like DAX below.

     

    CurrentSales = IF(ISFILTERED('Currency'[CurrencyName]),SUM(Table1[sales])*VALUES('Currency'[Rate]),SUM(Table1[sales]))

    Best Regards,

    Amy

     

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

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

Hi  mmazzalay ,

 

You can create a new table named Currency like below:

CurrencyName

Rate

USD

1

ARS

45.05

 

Assuming to take US dollar as the basic currency rate, let the [CurrencyName] in Currency as the source of Slicer visual. Then you can create a new measure like DAX below.

 

CurrentSales = IF(ISFILTERED('Currency'[CurrencyName]),SUM(Table1[sales])*VALUES('Currency'[Rate]),SUM(Table1[sales]))

Best Regards,

Amy

 

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