Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Mohan128256
Helper III
Helper III

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

 

1 REPLY 1
Greg_Deckler
Community Champion
Community Champion

@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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.