I have read several posts and some articles about the optimization of a Dax measure but I am having some issue to put these advices into fruition. I am trying to had a measure flagging Inventory Items (direct SSAS connection) into a table. Here is the measure i campe up with:
I am having a similar problem, and I've read much of the posts here on optimization, but I must be missing something. The only big fact table I have is a Date Table - everything else is based on measures and dates. It was working just fine until I created this measure:
Thanks. I've sort of solved this myself by creating a separate table with only January 1 of each year in the dates column, and using this table instead of the central dates table in the SUMMARIZE statement. Now the refresh is down to about 30 seconds.