Need to Get Currency Exchange Rate from FX table based on the Max of date from slicer and Get max of

[mshiva]

Need to Get Currency Exchange Rate from FX table based on the Max of date from slicer and Get max of date and apply same rates for all transaction . 

Ex: Date Slicer Jan 8-1-2023 and Currency Code = 'EUR'

Now I need to get  exchance rate of 8-1-2023 and Currency Code = 'EUR' ,exchange rate is 1.5 . I need to mutiply all transactions with 1.5 where currency code is EUR . 

Currently there is no Join to Fact and FX Table 

[mshiva]

I have calender has filter not Currency . 

[amitchandak]

@mshiva , Create a measure like

Amount EUR =

var _max - maxx(filter(FxRate, FxRate[Curr] = selectedvalues(Curr[Curr])

&& FxRate[date]= selectedvalues(Date[DAte]) ), FxRate[Rate])

return

sumx(Table, Table[Amount]*_max)

[mshiva]

       If i keep Currency Code hardcoded its working . When i remove that it is not working . Throwing error like mutliple value expecting 

    SUMX(

        VALUES( 'Calendar'[Date]),

        VAR vExchangeRate =

            LOOKUPVALUE(

                'Dim FX'[drate],

                 'Dim FX'[dtdate - Copy]  ,SELECTEDVALUE('Calendar'[Date])

                 ,'Dim FX'[fr_scode],"EUR")

        RETURN

            1 * vExchangeRate

    )