Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
azizrasul
Regular Visitor

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.". 

1 ACCEPTED SOLUTION
vicky_
Super User
Super User

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}

 

View solution in original post

3 REPLIES 3
Ahmedx
Super User
Super User

Ahmedx
Super User
Super User

pls try htis

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

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}

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.