Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
abhishekdas72
Frequent Visitor

Explanation in layman terms for summarize & summarizecolumns

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
abhishekdas72_0-1680804346489.png

 

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])
abhishekdas72_1-1680804485244.png

Please help i am confused.

3 REPLIES 3
olgad
Super User
Super User

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] )
)

 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime
olgad
Super User
Super User

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.

olgad_0-1680807156338.png

 

 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

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 😞

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors