Error in Formula

[azizrasul]

I am trying to obtain a measure using the following: -

Sales Measure = SUMX(FILTER(InvoiceData, NOT(InvoiceData[CustomerID] IN (1001, 1002))), InvoiceData[Sales]*InvoiceData[Quantity])

I get the error "Operator or expression '()' is not supported in this context.". 

[Ahmedx]

read this it will be useful too

https://www.sqlbi.com/articles/using-tuple-syntax-in-dax-expressions/

[Ahmedx]

pls try htis

Sales Measure =
SUMX (
    FILTER ( InvoiceData, NOT ( InvoiceData[CustomerID] IN { 1001, 1002 } ) ),
    InvoiceData[Sales] * InvoiceData[Quantity]
)

[vicky_ · Accepted solution]

The error comes from this part: 

 IN (1001, 1002)

https://www.sqlbi.com/articles/using-tuple-syntax-in-dax-expressions/

read the above, or TLDR, just change it to:

IN {1001, 1002}