Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
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] )
)
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
19 | |
14 | |
10 | |
7 |