Forum Discussion

hibarrbm's avatar
hibarrbm
Helper I
6 years ago

Token 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_...
hibarrbm's avatar
hibarrbm
Helper I
6 years ago

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

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago
// 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's avatar
    hibarrbm
    Helper I
    6 years ago

    Looks like the measure was accepted except now it returns back with zero. any idea why that is?

     

     

  • hibarrbm's avatar
    hibarrbm
    Helper I
    6 years ago

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

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      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}