Problem with Measure total while using sumX

[KevBI]

Hello PowerBI Pro's !

I have a small Measure that takes Values and divides it with an exchange Rate. Somehow the Totals don't add up correctly even when using sumX.

Total PO Value = SUMX('EKPO (2)', [Net Order Value]) / EKBE[_ExchangeRate]

I made a second Measure without the exchange Rate and there the total is calculated correctly ->

PO value without exchnage rate = SUMX('EKPO (2)', [Net Order Value])

The Exchange Rate Measure looks like this:

_ExchangeRate =

VAR

    _currency = max(EKBE[Currency])

VAR

    _conversionRate =

    CALCULATE(

            MAX( 'exch  rate AOP 2022'[Exchange Rate new Format])

            , 'exch  rate AOP 2022'[Currency] = _currency

    )

RETURN

_conversionRate

What can be changed so the total will be shown correctly even when the value is divided by the exchange rate?

Thank you guys!

[v-jayw-msft]

Hi @KevBI ,

If I understood you correctly, you could use ISFILTERED() function to calculate the row value and total value separately.

If I misunderstood your meaning, please share some sample data so that we could test the formula.

Best Regards,

Jay

[KevBI]

I also tried this Measure out :

_ExchangeRate2 =

VAR

_currency = max(EKBE[Currency])

VAR

_conversionRate =

Sumx(Values(EKBE[Purchasing Document]) , CALCULATE(

MAX( 'exch  rate AOP 2022'[Exchange Rate new Format])

, 'exch  rate AOP 2022'[Currency] = _currency

))

RETURN

_conversionRate

nothing seems to work...