Provide Optimized DAX version

Mohan128256 — Mon, 19 Aug 2024 10:14:38 GMT

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

Re: Provide Optimized DAX version

Greg_Deckler — Mon, 19 Aug 2024 11:22:37 GMT

Mohan128256 If I understand the ask, this looks like a simple Lookup Min/Max. Lookup Min/Max - Microsoft Fabric Community

See attached PBIX below signature.

topic Provide Optimized DAX version in DAX Commands and Tips

Provide Optimized DAX version

Re: Provide Optimized DAX version