Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Icon for Impactful Individual rankImpactful 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])
)
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

ovetteabejuela are you not wanting this? 

 

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

ovetteabejuela's avatar
ovetteabejuela
Icon for Impactful Individual rankImpactful Individual
9 years ago

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

 

  • sdjensen's avatar
    sdjensen
    Icon for Solution Sage rankSolution Sage
    9 years ago

    ovetteabejuela,

     

    You could try this:

    Measure = 
DIVIDE(
	SUMX( Table1; Table1[Num] * Table1[Den]);
	SUM(Table1[Den])
)
    • ovetteabejuela's avatar
      ovetteabejuela
      Icon for Impactful Individual rankImpactful 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.

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    9 years ago

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

    • ovetteabejuela's avatar
      ovetteabejuela
      Icon for Impactful Individual rankImpactful Individual
      9 years ago

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