Explanation in layman terms for summarize & summarizecolumns

[abhishekdas72]

Hello Community,

Can someone please explain me in a layman terms what is happening here.

i am trying to total all the values in a table product code so i wrote measure = sum(spend) and pulled this into a card for which i get correct value. but when i write summarizecolumns or summarize

Measure = sum(Sheet1[spend]) i pulled this in a card visual which gives me correct value
however when i write summarize/summarizecolumns i am not understanding what is happening here and how is PBI calculating 63K value 

Table = SUMMARIZECOLUMNS(Sheet1[productcode],Sheet1[spend])

Table 2 = SUMMARIZE(Sheet1,Sheet1[productcode],Sheet1[spend])

Please help i am confused.

[olgad]

The way you write summarizecolumns is a bit different, but once again you have to put an aggregation there and summarizecolumns versus summarize are more efficient from the querying dataset perspective.  You don't have to specify table here.

Sales by Year and Color =

SUMMARIZECOLUMNS (

    'Date'[Calendar Year],

    'Product'[Color],

    "Sales Amount", SUMX ( Sales, Sales[Quantity] * Sales[Unit Price] )

)

[olgad]

Can you try SUMMARIZE(Sheet1,Sheet1[productcode],"Spend", Sum(Sheet1[spend]))

Always try to create a small dataset to be able to understand whats going on.

My table has Product 1 with the price 5 and 2 and then product 2 -3 lines 10, 10, 50
Look at these tables, because Product 1 had 2 distinct values it calculates correctly, but product 2 had twice value 10 and in summarize it makes the sum of the distinct values and says 60, distinct 10 plus 50.
So thats why you have to create summarize the way i showed to you in the formula so you sum up all values for product 2.

[abhishekdas72]

Thnakyou for this explanation. It really helped .. didnot find this level of explanation anywhere on internet. will this also work on Summarizecolumns . what does summarizecolumns do?

i am not able to attach any excel files to the share with the community 😞