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
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
2 years ago

It might help to make the max date a variable.

Measure =
VAR _MaxDate = MAX ( 'Date'[Date] )
RETURN
    CALCULATE (
        COUNT ( 'Table'[Value] ),
        ALL ( 'Table' ),
        'Table'[ValidFromDate] < _MaxDate,
        'Table'[ValidToDate] > _MaxDate
    )
zazaalaza's avatar
zazaalaza
Frequent Visitor
2 years ago

Thanks but that doesn't help.