Optimize complex dax measure

Hello All,

After going through all the possible ways of optimization of a measure which i have written, I am reaching out to you community members to help me out.

below is dax query which i have written to get the new customer reference name if there are any changes happend in within the date range selected based on sales order id, product id and line creation number.

Customer Reference (H) New = 
VAR _MinDate =
    CALCULATETABLE(
        ADDCOLUMNS(
            SUMMARIZE(
                'Sales Orders Snapshots',
                'Sales Orders Snapshots'[Sales Order ID (H)],
                'Sales Orders Snapshots'[Product ID (L)],
                'Sales Orders Snapshots'[Line Creation Sequence Number (L)]
            ),
            "@SnapDate", Max( 'Sales Orders Snapshots'[SnapDate] )
        ),
        ALLSELECTED()
    )
VAR _FilterSnap =
    TREATAS(
        _MinDate,
        'Sales Orders Snapshots'[Sales Order ID (H)],
        'Sales Orders Snapshots'[Product ID (L)],
        'Sales Orders Snapshots'[Line Creation Sequence Number (L)],
        'Sales Orders Snapshots'[SnapDate]
    )
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)]
        ),
        KEEPFILTERS( _FilterSnap )
    )
RETURN _Result

 this measure gives me right value but when i see the Server engine and formula engine timings it still bothering me as it is taking 18+seconds.

DAX Query from performance analyzer

// DAX Query
DEFINE
	VAR __DS0Core = 
		SUMMARIZECOLUMNS(
			'Sales Orders Snapshots'[Sales Order ID (H)],
			'Sales Orders Snapshots'[Product ID (L)],
			'Sales Orders Snapshots'[MGA Original Customer ID (H)],
			'Sales Orders Snapshots'[MGA Original Customer Name],
			'Sales Orders Snapshots'[Original Legal Entity (L)],
			'Sales Orders Snapshots'[Order Created Date (H)],
			'Sales Orders Snapshots'[Original Region Name (H)],
			'Sales Orders Snapshots'[Original Sales Entity Name (H)],
			'Sales Orders Snapshots'[Original Forecast Responsible Group Name (H)],
			'Sales Orders Snapshots'[Original SPA Name (H)],
			'Sales Orders Snapshots'[Sales Responsible Name (H)],
			'Sales Orders Snapshots'[D365 SO Link],
			'Sales Orders Snapshots'[Product Name],
			'Sales Orders Snapshots'[Line Creation Sequence Number (L)],
			'Sales Orders Snapshots'[Line Created Date (L)],
			'Sales Orders Snapshots'[MGA Original Order ID (L)],
			"Customer_Reference__H__New", 'Sales Orders Snapshots'[Customer Reference (H) New]
		)

	VAR __DS0PrimaryWindowed = 
		TOPN(
			501,
			__DS0Core,
			[Customer_Reference__H__New],
			0,
			'Sales Orders Snapshots'[Sales Order ID (H)],
			1,
			'Sales Orders Snapshots'[Product ID (L)],
			1,
			'Sales Orders Snapshots'[MGA Original Customer ID (H)],
			1,
			'Sales Orders Snapshots'[MGA Original Customer Name],
			1,
			'Sales Orders Snapshots'[Original Legal Entity (L)],
			1,
			'Sales Orders Snapshots'[Order Created Date (H)],
			1,
			'Sales Orders Snapshots'[Original Region Name (H)],
			1,
			'Sales Orders Snapshots'[Original Sales Entity Name (H)],
			1,
			'Sales Orders Snapshots'[Original Forecast Responsible Group Name (H)],
			1,
			'Sales Orders Snapshots'[Original SPA Name (H)],
			1,
			'Sales Orders Snapshots'[Sales Responsible Name (H)],
			1,
			'Sales Orders Snapshots'[D365 SO Link],
			1,
			'Sales Orders Snapshots'[Product Name],
			1,
			'Sales Orders Snapshots'[Line Creation Sequence Number (L)],
			1,
			'Sales Orders Snapshots'[Line Created Date (L)],
			1,
			'Sales Orders Snapshots'[MGA Original Order ID (L)],
			1
		)

EVALUATE
	__DS0PrimaryWindowed

ORDER BY
	[Customer_Reference__H__New] DESC,
	'Sales Orders Snapshots'[Sales Order ID (H)],
	'Sales Orders Snapshots'[Product ID (L)],
	'Sales Orders Snapshots'[MGA Original Customer ID (H)],
	'Sales Orders Snapshots'[MGA Original Customer Name],
	'Sales Orders Snapshots'[Original Legal Entity (L)],
	'Sales Orders Snapshots'[Order Created Date (H)],
	'Sales Orders Snapshots'[Original Region Name (H)],
	'Sales Orders Snapshots'[Original Sales Entity Name (H)],
	'Sales Orders Snapshots'[Original Forecast Responsible Group Name (H)],
	'Sales Orders Snapshots'[Original SPA Name (H)],
	'Sales Orders Snapshots'[Sales Responsible Name (H)],
	'Sales Orders Snapshots'[D365 SO Link],
	'Sales Orders Snapshots'[Product Name],
	'Sales Orders Snapshots'[Line Creation Sequence Number (L)],
	'Sales Orders Snapshots'[Line Created Date (L)],
	'Sales Orders Snapshots'[MGA Original Order ID (L)]

Server Timings:

Server engine as 3 scans:

Scan1 Query:

SELECT 'Sales Orders Snapshots'[Sales Order ID ( H ) ], 'Sales Orders Snapshots'[Line Creation Sequence Number ( L ) ], 'Sales Orders Snapshots'[Product ID ( L ) ] FROM 'Sales Orders Snapshots';   

Scan2 Query: 

SELECT 'Sales Orders Snapshots'[Sales Order ID ( H ) ], 'Sales Orders Snapshots'[Line Creation Sequence Number ( L ) ], 'Sales Orders Snapshots'[Product ID ( L ) ], MAX ( 'MinMaxColumnPositionCallback' ( PFDATAID ( 'Sales Orders Snapshots'[Customer Reference ( H ) ] ) ) ) FROM 'Sales Orders Snapshots' WHERE  ( 'Sales Orders Snapshots'[Sales Order ID ( H ) ], 'Sales Orders Snapshots'[Product ID ( L ) ], 'Sales Orders Snapshots'[Line Creation Sequence Number ( L ) ], 'Sales Orders Snapshots'[SnapDate] ) IN { ( '100S1040554', '656040-M8', '1', 45553.000000 ) , ( '100S0587644', '662737-000', '1', 45553.000000 ) , ( '411S0083387', '651489-E7', '4', 45553.000000 ) , ( '411S0094134', '593140-RF', '4', 45553.000000 ) , ( '100100S1115042', '541301-C3', '1', 45553.000000 ) , ( '100S0987039', '514527-CBULK', '7', 45553.000000 ) , ( '100S0112135', '618338-M', '1', 45553.000000 ) , ( '100S0331324', '587187-C3', '7', 45553.000000 ) , ( '100100S0377131', '587378-EUC', '39', 45553.000000 ) , ( '100S0599708', '591856-X2EUCALT', '3', 45553.000000 ) ..[20,49,990 total tuples, not all displayed]};   Estimated size: rows = 20,47,054  bytes = 3,27,52,864

Scan3 Query:

SELECT 'Sales Orders Snapshots'[D365 SO Link], 'Sales Orders Snapshots'[Product Name], 'Sales Orders Snapshots'[Sales Order ID ( H ) ], 'Sales Orders Snapshots'[Line Creation Sequence Number ( L ) ], 'Sales Orders Snapshots'[Product ID ( L ) ], 'Sales Orders Snapshots'[MGA Original Customer ID ( H ) ], 'Sales Orders Snapshots'[MGA Original Customer Name], 'Sales Orders Snapshots'[Original Forecast Responsible Group Name ( H ) ], 'Sales Orders Snapshots'[Original Region Name ( H ) ], 'Sales Orders Snapshots'[Original Sales Entity Name ( H ) ], 'Sales Orders Snapshots'[Original SPA Name ( H ) ], 'Sales Orders Snapshots'[Order Created Date ( H ) ], 'Sales Orders Snapshots'[Original Legal Entity ( L ) ], 'Sales Orders Snapshots'[Sales Responsible Name ( H ) ], 'Sales Orders Snapshots'[MGA Original Order ID ( L ) ], 'Sales Orders Snapshots'[Line Created Date ( L ) ] FROM 'Sales Orders Snapshots';   Estimated size: rows = 20,49,991  bytes = 13,11,99,424

Any suggestions or changes over the measure which i have written.

Please help.

Thanks,

Mohan V.