Forum Discussion

Dennis_Pedersen's avatar
Dennis_Pedersen
Icon for Helper I rankHelper 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...
Dennis_Pedersen's avatar
Dennis_Pedersen
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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
    Icon for Helper I rankHelper I
    4 years ago

    Hi amitchandak

     

    Thank you - I have sent you a PM

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity 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