Help with measure

[serapinasnovian]

Hello, can someone help me with measure. Why is it so slow?

VAR maxdate =
CALCULATE ( MAX ( 'Fact'[Date] ), 'Fact'[type] = "KASA" )
VAR result =
CALCULATE ([Amount],
KEEPFILTERS ( 'Fact'[type] = "KASA" ),
KEEPFILTERS ( Date[Date] = maxdate ))
RETURN
result

[amitchandak]

@serapinasnovian , seems fine at first look.

Try this small variation

VAR maxdate =
CALCULATE ( MAX ( 'Fact'[Date] ), filter('Fact','Fact'[type] = "KASA" ))
VAR result =
CALCULATE ([Amount],
FILTERS ( 'Fact', 'Fact'[type] = "KASA" ),
FILTERS ( Date, Date[Date] = maxdate ))
RETURN
result