Calculated column IF always returns FALSE

[Fraukje]

I have the following calculated column, and for some reason it will always return to the FALSE expression (i.e. it always uses the RateToDollar):

TransactionAmountConverted = CALCULATE(VALUES(Transactions[TransactionAmount]) * (IF([CurrencyFilter] = "EUR", VALUES('Currency'[RateToEuro]), VALUES('Currency'[RateToDollar]))))

 The CurrencyFilter is a calculated measure that gets a report level filter value:

CurrencyFilter = IF(LASTNONBLANK('CurrencyFormat'[Name], 1) = "USD", "USD", "EUR")

I have tested the CurrencyFilter value and it is a 'text' value that indeed is set to "USD" or "EUR" depending on the report filter. Now I really do not understand why the IF statement in the calculated column always goes to the FALSE part...

Anyone has any ideas? Any help is much appreciated!

[Greg_Deckler]

Hmm, that's probably a difficult one to troubleshoot, it is most like some kind of context issue.

[Fraukje]

Any ideas how to troubleshoot it?

[Greg_Deckler]

Would need some sample/example data or for you to share a link to your PBIX file. Context issues are tricky.

[Fraukje]

Part of my data modelSample data

The original transaction amounts can be in any currency available in the Currency table. Based on the user's choice of report filter (currently either USD or EUR), the Transaction Amount should display the transaction's converted amount. So for example, if the user selects 'EUR' in the report filter, the Transaction Amount column should display all original transaction amounts converted to euros. Similarly, if the user would select dollar, for dollars.

Oh, and the CurrencyFormat was created for the sole reason to act as a report filter.

[Fraukje]

Could it be that a calculated column cannot handle dynamicly set values from a report filter? Would you know anything about this?