DAX Simple Math | Not Averaging or Aggregating Properly or it is just me?

[ovetteabejuela]

Hi COmmunity,

Why is this not doing average:

Num	Den	Column1
23.42	4479	A
24.36	5230	B
23.31	3823	C
23.81	5577	D
23.88	3948	E
23.87	5846	F

[vanessafvg]

@ovetteabejuela well according to your calculation its coming up with the correct value.  What are you trying to do?

[ovetteabejuela]

@vanessafvg

I want to achieve highlighted in yellow

asd = sorry about the field name but it is just Num * Den (23.42 * 4479 = 104898.2)

[vanessafvg]

@ovetteabejuela are you not wanting this? 

measure = divide(sum(num)/countrows(table of denominator))

[ovetteabejuela]

That is just like straight average, I'm doing some kind of reverse calculation here to get the correct average:

[sdjensen · Accepted solution]

@ovetteabejuela,

You could try this:

Measure = 
DIVIDE(
	SUMX( Table1; Table1[Num] * Table1[Den]);
	SUM(Table1[Den])
)

[ovetteabejuela]

Thanks @vanessafvg and @sdjensen,

So that's what I should be using SUMX! I'll read about that to understand the equation more.

[vanessafvg]

@ovetteabejuela so then why not just calculate(divide(sum(num),sum(den))

[ovetteabejuela]

Sorry the field names are misleading... here, how about this: