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 well according to your calculation its coming up with the correct value.  What are you trying to do?

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

    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'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: