Forum Discussion
Token Comma Expected Error
[Your Measure] =
CALCULATE(
0 + SUM ( 'ODS_OWNER FACT_ORDER_LINE'[TOTAL_SALE_PRICE] ),
KEEPFILTERS( 'ODS_OWNER FACT_ORDER_LINE'[ORDER_LINE_FLG] <> 1 )
)Your expression is correct. If you have any problems with a formula and syntax, use www.daxformatter.com. I've checked it and it's OK. But your formula is not only unnecessary complex. It's also slower than it could be. The version above is MUCH faster.
Thank you daxer! this worked perfectly.
I also need to add an extra filter to the statement, i also need to only apply to order status key that = 25 or 133
Does this work:
CALCULATE (
0 + SUM ( 'ODS_OWNER FACT_ORDER_LINE' [TOTAL_SALE_PRICE]),
KEEPFILTERS( 'ODS_OWNER FACT_ORDER_LINE' [ORDER_STATUS_KEY] = (25,133)).
KEEPFILTERS( 'ODS_OWNER FACT_ORDER_LINE' [ORDER_LINE_FLG] <>1).
)
Thanks,
Hugo
// I'd shorten the name of the table // ODS_OWNER FACT_ORDER_LINE. If you // can shorten the names of the columns // - even better. [Your Measure] = CALCULATE( 0 + SUM ( 'ODS_OWNER FACT_ORDER_LINE'[TOTAL_SALE_PRICE] ), KEEPFILTERS( 'ODS_OWNER FACT_ORDER_LINE'[ORDER_LINE_FLG] <> 1 ), KEEPFILTERS( 'ODS_OWNER FACT_ORDER_LINE'[ORDER_STATUS_KEY] IN {25, 133} ) )Looks like the measure was accepted except now it returns back with zero. any idea why that is?
Apologizes, this is the second filter that needs to be applied. Once i updated the formula it gave me the following error message:
Test Sales New = CALCULATE (0 + SUM ( 'FACT_ORDER_LINE'[TOTAL_SALE_PRICE] ),KEEPFILTERS ( 'FACT_ORDER_LINE'[ORDER_STATUS_KEY] <> {27,22,20,18,23,19,-2,109,110}),KEEPFILTERS ( 'FACT_ORDER_LINE'[ORDER_LINE_FLG] <> 1 ))- You can't write
'FACT_ORDER_LINE'[ORDER_STATUS_KEY] <> {27,22,20,18,23,19,-2,109,110}
since the LHS is a scalar and the RHS is a set. When you compare objects they must be of the same type.
The correct condition is
NOT 'FACT_ORDER_LINE'[ORDER_STATUS_KEY] IN {27,22,20,18,23,19,-2,109,110}