Forum Discussion

Dennis_Pedersen's avatar
Dennis_Pedersen
Icon for Helper I rankHelper I
2 years ago

SumX not working properly - filter problem?

Hi  I want to calculate my total netweight sold as a measure (not calculated column) So I just want to multiply the qty sold with the netweight from my itemtable.   As you can see from the 2 matr...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

Dennis_Pedersen's avatar
Dennis_Pedersen
Icon for Helper I rankHelper I
2 years ago

Thanks but unfortunatetely it looks the same.

You mean formulas like below?

 

Netweight from Item:

CALCULATE(
average(vDIM_Items[NetWeight])
, ALLSELECTED(vDIM_Items[ItemID])

 

SUMX(ALLSelected-wrong:

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