Forum Discussion
Solved
Error in Formula
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]) ...
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}
pls try htis
Sales Measure =
SUMX (
FILTER ( InvoiceData, NOT ( InvoiceData[CustomerID] IN { 1001, 1002 } ) ),
InvoiceData[Sales] * InvoiceData[Quantity]
)