Forum Discussion
VizsWork
7 years agoRegular Visitor
Dax Optmisation
Hi All Help!!!!! How can I make this dax code faster its too slow and i dont like it HeadCount 12M (ColleagueType) = VAR MonthSelected = SELECTEDVALUE(Calender[End of Month],EOMONTH(UTCTODAY()...
v-frfei-msft
7 years agoCommunity Support
Hi VizsWork ,
We can use GROUPBY instead of SUMMARIZE. Please refer to the third - party blog.
https://www.sqlbi.com/articles/nested-grouping-using-groupby-vs-summarize/