Different totals: Two separate measures VS One combined measure

[Powermac]

Hello:)

Could anybody assist me with explaining why I get differerent totals if I

- write two seperate meassures with the second measure using the first or

- write only one measure that contains the whoe but else same code?

I have a FxOrder calculation that calculates/looks up the effective exchangerate valid for specific order in an Orders table.  Then I want to multiply each order price with its FxOrder value and sum it up.

Option A: A measure for FxOrder and a second, separate measure for Converted Amount that uses FxOrder:

Option B: No FxOrder measure but instead, the (same) code for FxOrder written directly in the measure Converted Amount3/2.

Without variables:

With variables:

If I write the separate measures, results and totals are as expected. If I write it in one measure, the total is being calcualte differently (multiplicaiotn of the argument totals instead of sum over the single results.

How do I have to understand the order of the calculations and why the totals a different?

Many thanks!!

[Fowmy]

@Powermac 

when you create a variable fxordervar and use it in another iteration as SUMX ( orders, fxordervar..... it doesn't get evaluated against each order as the variable once defined, it behaves as a constant. You need to write the complete measure.