Currency conversion

Hi Anonymous 

You may refer to my sample.

Transaction:

Rate - EUR:

I create a Currency table by dax to build slicer.

Currency = VALUES('Rate - EUR'[Currency])

Measures:

Basic Measure = 
VAR _Rate = IF(MAX('Transaction'[currency]) = "EUR",1,CALCULATE(SUM('Rate - EUR'[Rate - EUR]),FILTER(ALL('Rate - EUR'),AND('Rate - EUR'[Date]=MAX('Transaction'[Date]),'Rate - EUR'[Currency]=MAX('Transaction'[currency])))))
VAR _EUR = DIVIDE(SUM('Transaction'[Value]),_Rate)
VAR _SELECTCURRENCY = SELECTEDVALUE('Currency'[Currency])
VAR _SELECTRATE = CALCULATE(SUM('Rate - EUR'[Rate - EUR]),FILTER(ALL('Rate - EUR'),AND('Rate - EUR'[Currency] = _SELECTCURRENCY,'Rate - EUR'[Date] = MAX('Transaction'[Date]))))
VAR _SELECTVALUE = _EUR*_SELECTRATE
RETURN
IF(ISFILTERED('Currency'[Currency]),_SELECTVALUE,_EUR)

Value in Select Currency = SUMX('Transaction',[Basic Measure])

What Currency now? = IF(ISFILTERED('Currency'),SELECTEDVALUE('Currency'[Currency]),"EUR")

Build a date range slicer by Date column from Transaction table. Result is as below.

If there is no selection in currency slicer, [Value in Select Currency] measure will show values in rate of EUR. [What Currency now?] will show EUR.

If there is a selection in currency slicer like USD, [Value in Select Currency] measure will show values in rate of USD. [What Currency now?] will show USD.

Best Regards,
Rico Zhou

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