Forum Discussion
Hello help with sum values in the same column
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"))
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?
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.
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"))