topic Problem with SumX in DAX Commands and Tips

Problem with SumX

Dennis_Pedersen — Mon, 21 Feb 2022 10:16:53 GMT

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 calculation, see below.

It seems it has something to do with my time dimension, which I do not understand, bacause the item dimension has no relation to the time dimension. But if I choose "All" in B1 instead og "2021", the style at the bottom is calculation correct.

But that is not a solution, I need to choose different years in B1.

Can anyone help with a measure working correct? See my measure below

New measure:=

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

return

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

Re: Problem with SumX

amitchandak — Mon, 21 Feb 2022 11:03:02 GMT

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))

Re: Problem with SumX

Dennis_Pedersen — Mon, 21 Feb 2022 11:39:46 GMT

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))

Re: Problem with SumX

amitchandak — Mon, 21 Feb 2022 12:01:38 GMT

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

Re: Problem with SumX

Dennis_Pedersen — Tue, 22 Feb 2022 06:41:09 GMT

Hi amitchandak

Thank you - I have sent you a PM

Re: Problem with SumX

v-easonf-msft — Fri, 04 Mar 2022 01:37:37 GMT

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