Forum Discussion

limxx1's avatar
limxx1
Frequent Visitor
5 years ago

Sum with filter measure

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 ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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"}))