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

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        4 years ago

        Hi, Dennis_Pedersen 

        Could you please tell me whether your problem has been solved?

        If not, please provide sanitized sample data that fully covers your issue. 

        Best Regards,
        Community Support Team _ Eason