Forum Discussion
Solved
Problems with Exchange Rate calculation - especially when aggregating
I have a built a measure that calculates the FX Rate as following: Fx Rate= CALCULATE( SUMX('ExchangeRates','ExchangeRates'[Exchange_Rate]), STARTOFYEAR('Calendar'[Date]) This changes depending...
I've found a solution after all. I put the lookupvalue in the Sumx calculation instead of splitting them in two. The calculation then kept the row context.
