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.

      • Mohan128256's avatar
        Mohan128256
        Helper IV
        1 year ago

        Thanks for the suggestion AlexisOlson .

        This works fine when i try it on the sample dataset which i have shared with you.

         

        But the problem is all with when we have that whole table data and it takes almost 3min of time to render the visual.

         

        This is where the users are all complaining about report to have better performance.

         

        Please help. lbendlin AlexisOlson parry2k