Forum Discussion
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
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"))
