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
aparedes
Frequent Visitor

Hello help with sum values in the same column

Hello everyone!!

 

I´m new in this tool and I need your help in how to sum values in the same column

 

Here´s the situation:

 

I have one table and in one column I have different classifications and another column I have total of amounts.

 

The column of classification have different classifications but those classifications are repeated in all column and I need sum the ammounts for each classification

 

can you please help me with

 

Thanks and regards

1 ACCEPTED SOLUTION

@aparedes

 

Using measures:

 

VentasdeFria=Calculate(Sum('Tabla'[Ventas]),Filter(Tabla,Tabla[Clasificacion]="Fria"))

VentasdeSubProductos=Calculate(Sum('Tabla'[Ventas]),Filter(Tabla,Tabla[Clasificacion]="SubProductos"))

 

VentaFriaandSubProductos=[VentasdeFria]+[VentasdeSubProductos]

 

or If you want in 1 measure sum Both:

 

VentasdeFriaandSubProductos=Calculate(Sum('Tabla'[Ventas]),Filter(Tabla,Tabla[Clasificacion]="Fria" || Tabla[Clasificacion]="SubProductos"))




Lima - Peru

View solution in original post

6 REPLIES 6
Vvelarde
Community Champion
Community Champion

@aparedes

 

Hi, please post sample data.

 

Your data looks like:

 

Columna A    Columna B

CLASS1        100

CLASS2         80

CLASS3        70

CLASS2       50

CLASS3       70

 

And you need in a visualization

 

CLASS1 100

CLASS2  130

CLASS3  140

TOTAL  370

 

Is correct?




Lima - Peru

 

Hi, @Vvelarde that is exactly that I need and here some example of my data

 

Captura2.PNG

 

 

 

thanks and regards

@aparedes

 

Follow the Image instructions

 

Sigue las instrucciones de la imagen

 

SUm.gif




Lima - Peru

Hello @Vvelarde thanks for the quick answer.

 

This is for the visualization mode and I got it!! But we can do something in a table level like in a new column or calculation because I need with the new measure sum different classification for example

 

sum Classification "Fria" and Classification "Subproductos" in a new calculate fiel so I can Graph the new calculate field.

 

Please let me know if you need further information

 

Regards.

@aparedes

 

Using measures:

 

VentasdeFria=Calculate(Sum('Tabla'[Ventas]),Filter(Tabla,Tabla[Clasificacion]="Fria"))

VentasdeSubProductos=Calculate(Sum('Tabla'[Ventas]),Filter(Tabla,Tabla[Clasificacion]="SubProductos"))

 

VentaFriaandSubProductos=[VentasdeFria]+[VentasdeSubProductos]

 

or If you want in 1 measure sum Both:

 

VentasdeFriaandSubProductos=Calculate(Sum('Tabla'[Ventas]),Filter(Tabla,Tabla[Clasificacion]="Fria" || Tabla[Clasificacion]="SubProductos"))




Lima - Peru

hello @Vvelarde thanks for your help now is work properly with that calculation Smiley Happy

 

Now I can sum values in the same column

 

Thanks for all your support

 

Regards.-

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.