Sum with filter measure

[limxx1]

Hi,

I have the following set of data and would like to calculate the number of fruits = apple, orange & kiwi (able to apply to other similar/multiple filters scenario).

apple	2
orange	1
apple	6
kiwi	7
banana	4
.	.
.	.
.	.
kiwi	4

Thanks in advance !

[limxx1]

@amitchandak It works! thanks alot.

[amitchandak]

@limxx1 , the best way is to have a slicer on fruit and sum(Table[Value]) as a measure

or have a measure as per need

calculate( sum(Table[Value]) , filter(Table, Table[fruit] in {"apple", "Orange", "kiwi"}))