Forum Discussion

zazaalaza's avatar
zazaalaza
Frequent Visitor
2 years ago

DAX too Slow with Filtering

Hi, I have the following measure: Measure = CALCULATE ( COUNT ( 'Table'[Value] ), FILTER ( ALL ( 'Table' ), 'Table'[ValidFromDate] < MAX ( 'Date'[D...
all
Date
DAX
Filter
slow
zazaalaza's avatar
zazaalaza
Frequent Visitor
2 years ago

Perhaps there is a way to make it faster without using Calculate? Greg_Deckler Any ideas? 

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    2 years ago

    Yeah, I have seen this pattern be slow occasionally.

    Without CALCULATE can be written fairly similarly.

    Measure =
VAR _MaxDate = MAX ( 'Date'[Date] )
RETURN
    COUNTROWS (
        FILTER (
            ALL ( 'Table' ),
            'Table'[ValidFromDate] < _MaxDate &&
            'Table'[ValidToDate]   > _MaxDate
        )
    )