The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.".
Solved! Go to 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}
read this it will be useful too
https://www.sqlbi.com/articles/using-tuple-syntax-in-dax-expressions/
pls try htis
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}