Choose a specific item from the column and sum the value from another column

[Anonymous]

Price	Type
500$	Laptop
500$	Airpods
600$	Mobile
450$	Laptop
900$	Laptop
200$	Laptop

 i need from Type (Laptop) and sum price for just Laptop.

Best Regards.

[ryan_mayu · Accepted solution]

@Anonymous 

please try

CALCULATE(SUM(PRICE),FILTER(TABLE,TYPE="Laptop“))

[az38 · Accepted solution]

Hi @Anonymous 

Measure = CALCULATE(SUM(Table[Price]), Table[Type]="Laptop")

if you need this sum witout respect any filters try also

Measure = CALCULATE(SUM(Table[Price]), Table[Type]="Laptop", ALL(Table))​

[amitchandak]

@Anonymous , if you take type on slicer or take it a summarized column/axis/row  on a visual 

and use sum(table[Price]) that should do ?

[ryan_mayu · Accepted solution]

@Anonymous 

please try

CALCULATE(SUM(PRICE),FILTER(TABLE,TYPE="Laptop“))