Forum Discussion
YonghunLee
Helper I
6 years agoDifference between sumx and calcualate
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?
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/
1 Reply
- amitchandak
Super User
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/