Forum Discussion

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Still way too big. (619 MB)

     

    Distill it down further.

    • Mohan128256's avatar
      Mohan128256
      Helper IV
      1 year ago

      lbendlini have reduced to 1.3 mb with only 4 Salesorder id's data.
      Please check and let me know.

      • AlexisOlson's avatar
        AlexisOlson
        Super User
        1 year ago

        I think you can simplify your measure like this.

        Customer Reference (H) New = 
VAR _MaxDate =
    CALCULATE (
        MAX ( 'Sales Orders Snapshots'[SnapDate] ),
        ALLSELECTED ()
    )
VAR _Result =
    CALCULATE (
        MAX ( 'Sales Orders Snapshots'[Customer Reference (H)] ),
        ALLEXCEPT (
            'Sales Orders Snapshots',
            'Sales Orders Snapshots'[Sales Order ID (H)],
            'Sales Orders Snapshots'[Product ID (L)],
            'Sales Orders Snapshots'[Line Creation Sequence Number (L)]
        ),
        TREATAS ( { _MaxDate }, 'Sales Orders Snapshots'[SnapDate] )
    )
RETURN
    _Result

         

        This produces only two queries in my testing and neither query had those annoying tuples.