topic Re: Help with measure in DAX Commands and Tips

Help with measure

serapinasnovian — Tue, 25 May 2021 08:47:43 GMT

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

Re: Help with measure

amitchandak — Tue, 25 May 2021 14:19:30 GMT

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