Difference between sumx and calcualate

[YonghunLee]

From the table6(1), I made two measure and used it in matrix (2) and (3)

I though that two measure have the same result, But it didn’t.

Could you explain why they are diffent?

[amitchandak · Accepted solution]

@YonghunLee , Sum(A) all except working at the aggregated data.

refer if these can help in understanding

https://radacad.com/sum-vs-sumx-what-is-the-difference-of-the-two-dax-functions-in-power-bi

https://powerpivotpro.com/2014/10/sum-sumx-or-calculatechoices-choices/