Forum Discussion
hibarrbm
Helper I
6 years agoToken Comma Expected Error
Hi, I'm receiving the "Token Comma Expected" error for script below. = CALCULATE ( VAR TotalSalePrice = CALCULATE ( SUMX ( 'ODS_OWNER FACT_ORDER_LINE', IF ( 'ODS_OWNER FACT_ORDER_LINE'[ORDER_...
Anonymous
6 years agoNot applicable
// 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}
)
)hibarrbm
Helper I
6 years agoLooks like the measure was accepted except now it returns back with zero. any idea why that is?