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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
adityah
Frequent Visitor

How to summarize a table correctly

Hi,

 

Please excuse if the question seems trivial, I am a newbie and have tried various solutions which havent worked. I am trying to summarize a table 'Budget' which looks like this:

 

RegionPower BIUSDTypeCat.
xxNon-Motor12500ActualCAPEX
xxNon-Motor510.51ActualOPEX
xxNon-Motor2473.671ActualOPEX
xxNon-Motor757.4359ActualOPEX
yyNon-Motor680.5167ActualOPEX
yyNon-Motor1118.632ActualCAPEX
yyMotor6992ActualCAPEX
yyMotor4736.987ActualCAPEX
yyMotor757.4359ActualOPEX
yyMotor1740ActualCAPEX
yyMotor2967.308ActualCAPEX
xxMotor2294.103ActualCAPEX
xxMotor3191.795ActualCAPEX

 

to look like this:

 

RegionPower BIActualCat.
xxNon-Motor12500CAPEX
xxNon-Motor3741.616OPEX
yyNon-Motor680.5167OPEX
yyNon-Motor1118.632CAPEX
yyMotor16436.29CAPEX
yyMotor757.4359OPEX
xxMotor2294.103CAPEX

 

I don't actually need the column 'Type' and instead replace the USD column name with 'Actual'

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@adityah , a sum(Table[USD]) should work in table visual with all other columns

 

 

If you need a data table,

 

Summarize(Table, Table[Region], Table[Power BI], Table[Cat], "Actual", SUm(table[USD]))

 

Learn Power BI: Calculatetable, Summarize, Groupby, SummarizeColumns, Except, Distinct, Generateseries, Generate, Crossjoin
https://youtu.be/cN8AO3_vmlY?t=22350

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

FreemanZ
Super User
Super User

hi @adityah 

try to add a calculated table like:

Table = 
ADDCOLUMNS(
    SUMMARIZE(
        budget,
        budget[Region],
        budget[Power BI],
        budget[Cat.]
    ),
    "Actual",
    CALCULATE(SUM(budget[USD]))
)

it worked like:

FreemanZ_0-1683699784946.png

View solution in original post

2 REPLIES 2
FreemanZ
Super User
Super User

hi @adityah 

try to add a calculated table like:

Table = 
ADDCOLUMNS(
    SUMMARIZE(
        budget,
        budget[Region],
        budget[Power BI],
        budget[Cat.]
    ),
    "Actual",
    CALCULATE(SUM(budget[USD]))
)

it worked like:

FreemanZ_0-1683699784946.png

amitchandak
Super User
Super User

@adityah , a sum(Table[USD]) should work in table visual with all other columns

 

 

If you need a data table,

 

Summarize(Table, Table[Region], Table[Power BI], Table[Cat], "Actual", SUm(table[USD]))

 

Learn Power BI: Calculatetable, Summarize, Groupby, SummarizeColumns, Except, Distinct, Generateseries, Generate, Crossjoin
https://youtu.be/cN8AO3_vmlY?t=22350

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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