Forum Discussion
ovetteabejuela
Impactful Individual
Impactful IndividualDAX 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]) )
8 Replies
- vanessafvg
Community Champion
ovetteabejuela well according to your calculation its coming up with the correct value. What are you trying to do?
- ovetteabejuela
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
