Forum Discussion

data1234's avatar
data1234
Frequent Visitor
2 years ago

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...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

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] )
)