Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago
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  
Need Help
  • sdjensen's avatar
    sdjensen
    9 years ago

    ovetteabejuela,

     

    You could try this:

    Measure = 
DIVIDE(
	SUMX( Table1; Table1[Num] * Table1[Den]);
	SUM(Table1[Den])
)
sdjensen's avatar
sdjensen
Solution Sage
9 years ago

ovetteabejuela,

 

You could try this:

Measure = 
DIVIDE(
	SUMX( Table1; Table1[Num] * Table1[Den]);
	SUM(Table1[Den])
)
ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago

Thanks vanessafvg and sdjensen,

 

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