Forum Discussion

Mohan128256's avatar
Mohan128256
Icon for Helper IV rankHelper IV
2 years ago

Provide Optimized DAX version

Hi Greg_Deckler  Can you please help me in Optimizing the below DAX query. when we use the below DAX measure in a table visual , along with same kind of other measures , it is taking more rendering time 
can you please provide altenative for this .

To know more about the background of this please refer 
https://community.fabric.microsoft.com/t5/Desktop/Need-help-to-optimize-DAX-query/m-p/3220292

Final Status =
VAR _MinDate =
    CALCULATETABLE(
        ADDCOLUMNS(
            SUMMARIZE(
                'Sales Orders Snapshots',
                'Sales Orders Snapshots'[Sales Order ID (H)],
                'Sales Orders Snapshots'[Product ID (L)]
            ),
            "@SnapDate", MIN( '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'[SnapDate]
    )
VAR _Result =
    CALCULATE(
        MAX( 'Sales Orders Snapshots'[Sales Order Status Name (H)] ),
        ALLEXCEPT(
            'Sales Orders Snapshots',
            'Sales Orders Snapshots'[Sales Order ID (H)],
            'Sales Orders Snapshots'[Product ID (L)]
        ),
        KEEPFILTERS( _FilterSnap )
    )
RETURN _Result