Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

sumx question

hi, i want to create a weighted average as below image the most left is the numirator , and the most right is the denominator. i want to create: 5316278/1+314443/2 the result for each row i...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi MP_123,

 

Just keen to check.  What number are you expecting for the total? :)

  • MP_123's avatar
    MP_123
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Phil_Seamark-5,473,499.5

    the sum of the sumx

    5,316,278+157,221.50

     

    thanks

    • MP_123's avatar
      MP_123
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      this is the definition of sumx -

      Returns the sum of an expression evaluated for each row in a table.

       

      seems like it's not the sum of an expression-

      what the PBI does is sum(UsersCount)\2

       

      • Phil_Seamark's avatar
        Phil_Seamark
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi there,

         

        Any chance you can post the sample set of data that makes this up.  As well as the code you are using to build your [Target] measure.

         

        Cheers,