topic Re: Sum with filter measure in DAX Commands and Tips

Sum with filter measure

limxx1 — Mon, 20 Sep 2021 16:31:02 GMT

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 !

Re: Sum with filter measure

amitchandak — Mon, 20 Sep 2021 17:25:20 GMT

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

Re: Sum with filter measure

limxx1 — Tue, 21 Sep 2021 04:45:58 GMT

amitchandak It works! thanks alot.