Filter by currency

[mmazzalay]

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/2019        222   USD

The table shows sales in each single date in both currencies.
Is there any other way to solve this?

Any suggestions?

Regards, Marianela.

[v-xicai]

Hi  @mmazzalay ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai · Accepted solution]

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.