Forum Discussion

Dennis_Pedersen's avatar
Dennis_Pedersen
Helper I
4 years ago

Problem with SumX

Hi    I am trying to make a measure that is simply multiplying the sold QTY with the weight of each item.   The measure is working fine on some Styles(items), but on other styles there is no calc...
amitchandak's avatar
amitchandak
Super User
4 years ago

Dennis_Pedersen , try with these small changes

 


New measure:=

VAR _weight=
AVERAGEX(values(vDIM_Items[ItemID]),CALCULATE([NetWeight_])
, REMOVEFILTERS(DIM_Time))

return

sumx(values(vDIM_Items[ItemID]),CALCULATE([QTY]*_weight))

  • Dennis_Pedersen's avatar
    Dennis_Pedersen
    Helper I
    4 years ago

    Thank you amitchandak

     

    Unfortunately the same result with no calculation on the last style. I really don't get it bacause the sold Qty is calculated correct on that style also, so it should be possible to calculate the weight also??

     

    Also I changed you formula a bit:(before it said too many arguments for averageX function)

     

    VAR _weight=
    AVERAGEX(values(vDIM_Items[ItemID]),CALCULATE([NetWeight_]
    , REMOVEFILTERS(DIM_Time)))

    return

    sumx(values(vDIM_Items[ItemID]),CALCULATE([QTY]*_weight))

    • amitchandak's avatar
      amitchandak
      Super User
      4 years ago

      Dennis_Pedersen ,
      Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

      • Dennis_Pedersen's avatar
        Dennis_Pedersen
        Helper I
        4 years ago

        Hi amitchandak

         

        Thank you - I have sent you a PM