TotalMTD , TotalYTD is very slow for a specific table

[sathishdgl]

I created following measure in 2 tables, orders and shipments. Both are showing correct value. However measure in orders loads very fast but same measure formula in shipments is extremely slow

TOTALMTD( orders[amount], calendar[date])

time : 1524

is very fast but 

TOTALMTD (ship[amount], calendar[date])

is slow

time :6454

calendar is not marked as date table because it is having duplicates. i don't mind, because it is showing correct values

[some_bih]

Hi @sathishdglDAX functions like TOTAMTD or TOTALYTD are from group Time Intelligence which means the best work on Calendar / Date table. It is good for you to compare performance and similar, but to implement best practice create Calendar / Date table (and mark it without duplicate) and after that check perfomance.

Hope this help, kudos appreciate.