Forum Discussion
Solved
DAX Simple Math | Not Averaging or Aggregating Properly or it is just me?
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
You could try this:
Measure = DIVIDE( SUMX( Table1; Table1[Num] * Table1[Den]); SUM(Table1[Den]) )
That is just like straight average, I'm doing some kind of reverse calculation here to get the correct average:
ovetteabejuela so then why not just calculate(divide(sum(num),sum(den))
Sorry the field names are misleading... here, how about this: