Sumx Dont Working Well

[bestevez]

Hi,

I'm having trouble with the "SUMX" function. I don't understand why it doesn't add up. Attached is the metric created

SUMX(VALUES(dimDate[DWY]); CALCULATE( SUM(fac_Sales[Sales]); FILTER(ALL(dimDate); dimDate[DWY] = MAX(fac_Sales[DWYVenta])-1 )))

 

 Thanks

[nandukrishnavs · Accepted solution]

@bestevez  - Please go through this link https://radacad.com/sum-vs-sumx-what-is-the-difference-of-the-two-dax-functions-in-power-bi

Also, you can declare variables and debug step by step.

reference: https://radacad.com/some-simple-ways-to-debug-your-dax-measure-code-in-power-bi-debugging-virtual-ta...

If you are still confused, then please share the sample dataset/pbix file.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂