topic sum of measure (average) in DAX Commands and Tips

sum of measure (average)

ooctaviano — Tue, 29 Jun 2021 02:14:30 GMT

Hello

I have a table like the one I'm pasting below

I have to main columns I'm using qty (vtas pza) and cost

The issue i'm having is this

I created the following measures

1PROMVENTAS = AVERAGE(VENTAS[Vta Pzas]) - this is the average of units sold

2COSTOTOTAL = AVERAGE(VENTAS[COSTOPROM]) - this is the price

VTACTOTOTAL = AVERAGEX(VENTAS, VENTAS[COSTOPROM]*[1PROMVENTAS])

it want it to sum 304.37 from the 5th column,

For some reason it does not adds the results of the ids in the table if I do this for the sums instead of average it works, what am I doing wrong. The following is the case that works but I need averages of units and costs and then sum of totals.

VTACTOTOTAL = AVERAGEX(VENTAS, VENTAS[COSTOPROM]*[1PROMVENTAS])

VTACTOTOTAL = sumX(VENTAS, VENTAS[COSTOPROM]*[1PROMVENTAS])

Please advise

Re: sum of measure (average)

amitchandak — Tue, 29 Jun 2021 06:09:36 GMT

ooctaviano , if there are more than one rows for ID, this is what you can use

VTACTOTOTAL = AVERAGEX(VENTAS, VENTAS[COSTOPROM]*[1PROMVENTAS])

VTACTOTOTAL new = sumX(values(VENTAS[ID]),[VTACTOTOTAL])

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Re: sum of measure (average)

ooctaviano — Tue, 29 Jun 2021 15:57:03 GMT

It worked great

Thanks a lot