SumX not working properly - filter problem?

Hi Dennis_Pedersen 

You can try to modify the formula as follows:

Netweight from Item:

CALCULATE(
average(vDIM_Items[NetWeight])
, ALLSELECTED("Your table name", Yourcolumnname)
)

SUMX(ALLSelected-wrong:

sumx(allselected(vDIM_Items[ItemID]),[QTY]*[Netweight from Item])

If the problem persists, please provide detailed sample data: How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.