Multiplication using row context

[LamSar]

Hello everyone, 

I have a question.

I'm trying to calculate a measure "simulated sales", which is the average unit price of Week A * Total volume of Week B.

When I select 1 article, the calculation works fine. The moment I select more then 1 article, the result is wrong. It sums up al the average unit prices, then it is sums up all the total volume of Week B. And afterwards it does the multiplication.

But I need the multiplication row by row. 

The total I get for the example above is 10210.68, but I need to get 9775.

The measures I created are as follows:

Gem ehp Week A =

DIVIDE([Totale Omzet Week A], [Totaal Volume Week A],0)

Totale Omzet Week A = CALCULATE(SUM(Verkoop[BedragInclBTW]), ALL(Promotie),TREATAS(VALUES(VanDatum[Datum]), Datum[Datum]) )

Totaal Volume Week A = CALCULATE(SUM(Verkoop[VerkoopHoeveelheid]),ALL(Promotie), TREATAS(Values(VanDatum[Datum]), Datum[Datum]) )

Totaal Volume Week B =

Totaal Volume Week B = CALCULATE(SUM('Verkoop'[VerkoopHoeveelheid]), ALL(Promotie))

Any ideas on how to fix this?

[amitchandak]

@LamSar , try a measure like

Sumx(Values(Table[RetailArtikelOms]), [Gem ehp Week A]*[Totaal Volume Week B])