Slicer value to ignore the hardcoded value in measure.

[Ronak_1]

I have a measure which is sum of Total Sales of few selected products which we hardcoded in measure by using IN operator.

Example: 

Sales=CALCULATE(SUM(Sales),Product[Product Name] in {"A","B","C"})
Profit=Calculate(Sum(Profit))

I have a table which displays MonthYear, Sales, Profit. I also have a slicer of "Product" on report. Now when I select one or multiple products I want sales and profit measures to be filtered based on selected product in the slicer. The profit measure works as expected as it does not have product name hardcoded in the measure. 

I need help with Sales measure so that the measure value changes based on Product name slicer.

[Ronak_1]

I used below measure and it is working fine now in my case.
Sales=CALCULATE(SUM(Sales),Product[Product Name] in {"A","B","C"},Product[Product Name] in VALUES(Product[Product Name]))
Thanks.

[amitchandak]

@Ronak_1 , Try in one of the two ways

Sales=CALCULATE(SUM(Sales),filter(Product, Product[Product Name] in {"A","B","C"}) )

or

Sales=if(isfiltered(Product) , SUM(Sales),

CALCULATE(SUM(Sales),filter(Product, Product[Product Name] in {"A","B","C"}) ) )