How Calculated Column works and didn't understand how sumx is evaluated in calculated column ?

[Tarak_G]

Hi Team,

Just wanted to understand how calculated columns works ?

For Ex: 

I've written below two calculated columns in a table and these two calculated columns retuns the same result.

Here is the link for PBIX file  :https://1drv.ms/u/s!Au-aOkl1BoHugy-wjBKaEu957lDE?e=Pj8tbS

Calculated Columns :

Sales_Column = SUM(Sheet1[Sales])

Sumx_col = SUMX(Sheet1,Sheet1[Sales])

Here i didn't understand about the sumx_col : Sumx should calculate row by row but it will give us the total value like sum and attached below snap

Snap for result

Thanks In Advance

[amitchandak]

@Tarak_G , In the case of a column, a complete table is considered. So you will get the grand total.

They will differ in measure

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

https://exceleratorbi.com.au/use-sum-vs-sumx/