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])
I get the error "Operator or expression '()' is not supported in this context.".
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}
3 Replies
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] )read this it will be useful too
https://www.sqlbi.com/articles/using-tuple-syntax-in-dax-expressions/
