Forum Discussion
bestevez
Helper I
Helper ISumx Dont Working Well
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(...
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.
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 🙂
nandukrishnavs
Community Champion
Community Championbestevez - 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.
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 🙂