Sumx Dont Working Well

Question

Hi,&nbsp;I'm having trouble with the "SUMX" function. I don't understand why it doesn't add up. Attached is the metric created&nbsp;SUMX(VALUES(dimDate[DWY]); CALCULATE( SUM(fac_Sales[Sales]); FILTER(ALL(dimDate); dimDate[DWY] = MAX(fac_Sales[DWYVenta])-1 )))&nbsp;&nbsp;Thanks

nandukrishnavs · Accepted Answer

bestevez&nbsp; - Please go through this link&nbsp;https://radacad.com/sum-vs-sumx-what-is-the-difference-of-the-two-dax-functions-in-power-bi&nbsp;Also, you can declare variables and debug step by step.reference:&nbsp;https://radacad.com/some-simple-ways-to-debug-your-dax-measure-code-in-power-bi-debugging-virtual-tables&nbsp;If you are still confused, then please share the sample dataset/pbix file.&nbsp;Did I answer your question? Mark my post as a solution!Appreciate with a kudos 🙂

Forum Discussion

Sumx Dont Working Well

1 Reply

Related content

SumX

SUMX Not Working

SUMX

SUMX + CALCULATE not working

SUMX works, but not CALCULATE SUM