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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Mohamadmonem
Regular Visitor

how to sum some different values for a particular data in a new column?

Hello everybody,

I would like to get sum of the columnA values in a new column for each criteria which is located in column B. How to do that?

As I show in the table below, in the new column,  for every row, I would like to sum the values of column A based on the value of the column B and retrieve it the new column. For instance, for value (A) I expect to have 3000 (1000+2000)

Thanks in advance

ColumnAColumnBNew Column
1000A3000
2000A3000
1500B1500

 

 

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@Mohamadmonem 

This should work for you:

New Column = CALCULATE( SUM(Table[ColumnA]) , ALLEXCEPT( Table , Table[ColumnB] ) )
Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

3 REPLIES 3
Fowmy
Super User
Super User

@Mohamadmonem 

This should work for you:

New Column = CALCULATE( SUM(Table[ColumnA]) , ALLEXCEPT( Table , Table[ColumnB] ) )
Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Thank you very much my colleague for using a very power formular to solve this problem. Please can I ask if using the formular below would return the same result? If my result is different, please tell me why:

New Column =

       CALCULATE(

      SUM (Table[ColumnA]),

                       Table[ColumnB] = “A”

         )

Thanks, it works.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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