Forum Discussion
Mainer04401
Helper III
5 years agoOptimized MAXX & SUMMARIZE Expression
I need to calculate the maximum sales by any account in a user-specified geography, excluding the account in the filter or in the row. I have an expression that works but its very sluggish and I won...
v-easonf-msft
Community Support
5 years agoHi, Mainer04401
Please check whether these related threads help.
https://powerpivotpro.com/2014/01/another-way-to-find-the-top-performing-thing/
https://powerpivotpro.com/2017/09/dax-reanimator-series-top-performers-using-summarize/
Best Regards,
Community Support Team _ Eason