DAX Optimization - Summarize

[Anonymous]

Hi,

[Daniel29195]

@Anonymous 

iterating over the fact table is an expensive . 

im not sure about your model and what you want to get, 

but try to iterate over dimensions, 

im not sure why you need to group by the fact_sales[id] in summarize . 

hope this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠:

[Anonymous]

Hi Daniel,

thanks for reply, can you suggest an code, for instance I have tried addcolumns but it returns different values, if you can provide a code it can be great. regarding model you can think of it as 1 fact table, so logic is basic in the model.

Thanks in advance.