Total sum/multiply working incorectly

[mhsk]

This is strange but i hope you will help, so my model looks like this:

I would like to multiply PurNavLoc[QtyOh.] * PurNavCost[CostPrice] on Part[Part] and ActualDate[Date] level.

i created some measures but as long they work in table on single items level they do not want to give proper totals, pelase have a look:

Im expecting a total value of 22-07-2019 = 10 878 and 29-07-2019 = 8197 so te total value of items per date but i cant get that:

would you help?

[alexvc · Accepted solution]

The reason you are getting this inconsistency is because the measure is grouping at the total level as sum. There are two approaches you can try, one is to create a calculated columng for ExtCost = PurNavLoc[QtyOh.] * PurNavCost[CostPrice]. This will add up your extended cost at the total level correctly, since it will sum all of the single ext costs per line.

The other one can be to create an ExtCost measure, as SUMX(Part[Part],PurNavLoc[QtyOh.],PurNavCost[CostPrice]), it will sum the multiplication of PurNavLoc[QtyOh.] and PurNavCost[CostPrice] 

Let me know if it works

Alejandro

[mhsk]

hi,

it was a bit more complex in my casebut in general sumx solved the problem! Thanks

sumx ( TABLE ; expression ) 🙂