topic CALCULATE with multiple filters in DAX Commands and Tips

CALCULATE with multiple filters

Eesa — Thu, 16 Dec 2021 08:44:47 GMT

Hi all,

I want to create a simple DAX measure that calculates the sum of sales for the column product, selecting only "iphone", "Samsung" and "Hawaii".

I tried with below measure but it does not work.

Smart Phones Sales = CALCULATE(SUM(Sales[Price]), Sales[product] = "iPhone", Sales[product] = "Samsung", Sales[product] = "Hawaii")

Thank you for your help

Re: CALCULATE with multiple filters

Samarth_18 — Thu, 16 Dec 2021 09:54:34 GMT

Hi Eesa ,

You can try below code:-

Smart Phones Sales = CALCULATE ( SUM ( Sales[Price] ), FILTER ( Sales, Sales[product] = "iPhone" && Sales[product] = "Samsung" && Sales[product] = "Hawaii" ) )

iphone,samsung,hawaii is case sensitive so it should be written in same way as its available in dataset.

Thanks,

Samarth

Re: CALCULATE with multiple filters

Eesa — Thu, 16 Dec 2021 10:49:40 GMT

Hi Samarth,

Thank you for your reply. I tried but it does not work.
when I tried with single filter like:

Smart Phones Sales = CALCULATE ( SUM ( Sales[Price] ), FILTER ( Sales, Sales[product] = "iPhone" ))

It works well, but when I add another filter it gives me (Blank) with card visual. I tried to copy and paste the the word to avoid case errors but still does not work.

Re: CALCULATE with multiple filters

Samarth_18 — Thu, 16 Dec 2021 11:06:23 GMT

Eesa ,Try this

Smart Phones Sales = CALCULATE ( SUM ( Sales[Price] ), FILTER ( Sales, Sales[product] in { "iPhone","Samsung","Hawaii"} ))

Re: CALCULATE with multiple filters

Eesa — Thu, 16 Dec 2021 11:21:45 GMT

Thank you Samarth_18
It works!