Help with DAX formula with filtered Exchange rate

[NEMAT2313]

Hi,

I want to add new column that converting USD currency to the below table. USD currency table comes from Central bank Web sites and I put there filter by date. Please help me to write DAX formula that converts to USD in the new added column.

[NEMAT2313 · Accepted solution]

I found salutions from this form 

https://community.powerbi.com/t5/Desktop/Control-which-currency-is-displayed-with-slicer/m-p/61259?l...

My formula should be like this: 

U.E Remaining collcection = if(ISFILTERED('Курса валюты Доллар США'[Дата]);sum(Contract_3[Остаток невыплаченных средств])/VALUES('Курса валюты Доллар США'[Курс]);SUM(Contract_3[Остаток невыплаченных средств]))