how to get total of few selected materials

[Ashwin_Wadalkar]

Hi,

I have 100 + material codes & I want to get Sales of selected materials.

I gets sales of a single material code with below formula in "New Measure"

Sales = Calculate CALCULATE(([Sales Amt],(Sheet1[Material Code]="100495")

But, I fails with multiple material codes ;

Sales = Calculate CALCULATE(([Sales Amt],(Sheet1[Material Code]="100495","100395","100503")

Error.

Please advice.

Thanks in advance

Ashley

[Ashwin_Wadalkar]

Please guide me on which function i can use for ;

- And (viz....code "100495" And " 100395" And " 100503")

- OR   (viz....either code "100495" or " 100395" or " 100503")

Thanks

[Migasuke]

@Ashwin_Wadalkar 
not sure if I understand - but for And, use AND function:
https://docs.microsoft.com/en-us/dax/and-function-dax (or you can use operator &&)
for Or function use OR:
https://docs.microsoft.com/en-us/dax/or-function-dax

[Fowmy · Accepted solution]

@Ashwin_Wadalkar 

Use it this way:

Sales = 
CALCULATE(
    [Sales Amt],
    Sheet1[Material Code] IN {"100495","100395","100503"}
)

[Migasuke]

Hi,

Have you tried OR operator ||?
Try:
Sales = Calculate CALCULATE(([Sales Amt],(Sheet1[Material Code]="100495" || Sheet1[Material Code]= "100395" || Sheet1[Material Code]= "100503")