Forum Discussion

KevBI's avatar
KevBI
Icon for Helper I rankHelper I
4 years ago

Total doesn't calculate correctly

Hello Guys,   I have a simple Measure that retrieves the Exchange Rates per Currency, that works prefectly. When trying to calculate the price (Net Value) to EUR with the exchange Rate it also w...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

KevBI ,

_ExchangeRate =
VAR
_currency = max(EKBE[Crcy])
VAR
_conversionRate =
Sumx(Values(Table[Dco Number]) , CALCULATE(
MAX( 'exch rate AOP 2022'[Exchange Rate])
, 'exch rate AOP 2022'[Currency] = _currency
))

RETURN
_conversionRate