Forum Discussion
Aggregating currency conversions
Variables in DAX are constants, however odd this appears to be. Yes, once you define a variable, its value will never change. This is why your totals are incorrect.
You need to calculate the correct x-rate for each individual account that is visible in the current context.
OK, I understand that, but how do you suggest I do that? This is what I was trying to achieve with the SUMXs. What is odd, is that the exchange rate is correct for each account and it delivers the correct number - what is incorrect is the total. This is I think while it is correct row by row, in the row context of the total the VAR CurrS returns a value that is incorrect and instead of summing the (correct) row totals, the total performs the calculation with the wrong exchange rate