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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
data1234
Frequent Visitor

Syntax error in DAX If statement after hitting the save button

I am trying to transfer a simple formula to calculate net profit from one dashboard to another, the DAX statement appears to be correct when employed but it returns back a syntax error once I hit the save button.
This is the DAX statement:

Net Profit1 = 
IF (
    ISBLANK ( SUM ( Sales_marketplace[Purchases_combined.price] ) ),
    0,
    CALCULATE (
        SUM ( Sales_marketplace[price_total] )
            - SUM ( Sales_marketplace[Purchases_combined.price] )
            - SUM ( Sales_marketplace[per_imei_repair_cost] )
            - SUM ( Sales_marketplace[shipping_cost] ),
        FILTER (
            Sales_marketplace,
            Sales_marketplace[Purchases_combined.price] <> BLANK ()
        )
    )
)

 

And this is the syntax error returned:
The syntax for 'CALCULATE' is incorrect. (DAX(IF ( ISBLANK ( SUM ( Sales_marketplace[Purchases_combined.price] ) ), 0. CALCULATE ( SUM ( Sales_marketplace[price_total] ) - SUM ( Sales_marketplace[Purchases_combined.price] ) - SUM ( Sales_marketplace[per_imei_repair_cost] ) - SUM ( Sales_marketplace[shipping_cost] ), FILTER ( Sales_marketplace, Sales_marketplace[Purchases_combined.price] <> BLANK () ) )))).

Thank you very much in advance

1 REPLY 1
lbendlin
Super User
Super User

You are already filtering the blank sums. No need for a calculate.

 

Net Profit1 = 
IF (
    ISBLANK ( SUM ( Sales_marketplace[Purchases_combined.price] ) ),
    0,
    SUM ( Sales_marketplace[price_total] )
            - SUM ( Sales_marketplace[Purchases_combined.price] )
            - SUM ( Sales_marketplace[per_imei_repair_cost] )
            - SUM ( Sales_marketplace[shipping_cost] )
)

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.