CALCULATE with multiple filters

[Eesa]

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 

[Samarth_18]

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

[Eesa]

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. 

[Samarth_18 · Accepted solution]

@Eesa ,Try this

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

[Eesa]

Thank you @Samarth_18
It works!