Fixed Currency conversion change with filters

[Garyhb]

Currently, my data is in their local currency

i would need assistance on how to convert the currency respectively by just clicking the filter as shown below :

I have a fixed currency exchange rate in this table :

Sample data of the sales :

You may download the sample data here

Example 2.pbix (dropbox.com)

[Garyhb · Accepted solution]

Hi @Nahid_3152 

My revenue is in different currency like SGD/IDR/MYR so i can't use this measures :

Currentsales = IF(

ISFILTERED('Currency'[CurrencyName]),

SUM(Sheet1[Value])*SUM('Currency'[Rate]),

SUM(Sheet1[Value])
)

[v-luwang-msft]

Hi @Garyhb ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[TheoC]

hi @Garyhb 

check this out. Should help you: https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/

Hope this helps!

Theo

[Nahid_3152]

Hi,

Can you insert your currency value in the currency table?

[Garyhb · Accepted solution]

This is my currency table :

Which has "conversionRate"

This is the revenue data:

Example 1 : Store 6, the revenue is 68,487,038 IDR and it should be 4,775.8574 USD

Example 2: Store 4 has 15,392.57 MYR revenue. It should be  3,678.466 USD

Maybe you can take a look at the sample :

Example 2.pbix (dropbox.com)

Thank you

[Nahid_3152]

Hi,

Create a currency table. Then create a measure using 

Currentsales = IF(Currency TableData model1st Mesure2nd Mesure

ISFILTERED('Currency'[CurrencyName]),

SUM(Sheet1[Value])*SUM('Currency'[Rate]),

SUM(Sheet1[Value])

)

[Garyhb · Accepted solution]

Hi @Nahid_3152 

My revenue is in different currency like SGD/IDR/MYR so i can't use this measures :

Currentsales = IF(

ISFILTERED('Currency'[CurrencyName]),

SUM(Sheet1[Value])*SUM('Currency'[Rate]),

SUM(Sheet1[Value])
)