Forum Discussion

Frequent Visitor

9 years ago

Solved

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 classification...

Vvelarde
9 years ago
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"))