FX rates downloaded base on criteria

I would like to recevie "Bgt Avg YTD" for specific material. And later use it for calculation (Bgt Avg YTD * Value)

FX Rates

Currency

Reporting date

GRIP

The challenge that I have is that Currency is not unique in "FX Rates" table and I would like to receive it base on slicer "Reporting date". GRIP has only one Reporting date (31.01.2024).

Connections that I have are

I've tried to create measure

Miara test = CALCULATE(SUM('FX Rates'[Bgt Avr YTD]),DATESMTD('Reporting date'[Reporting date])) 

But I receive some total value, not correct FX rate.

I created two calculated columns on the GRIP table. To get the Bgt Avg YTD on the GRIP table, I recommend using a LOOKUPVALUE function searching both the Currency and the Reporting Date to bring back one value.

Bgt Avg YTD = 
LOOKUPVALUE('FX Rates'[Bgt Avg YTD], 'FX Rates'[Currency], GRIP[Purchase curr], 'FX Rates'[Reporting date], GRIP[Reporting date])

calculation = GRIP[Value] * GRIP[Bgt Avg YTD]