Forum Discussion
CALCULATE() or iterator function
There seems to be some personal preference involved with the use of CALCULATE(MAX()) versus MAXX() etc. I am still trying to understand the arguments pro and contra (as well as the context transitio...
If you read The Definitive Guide to DAX by The Italians, you'll find a chapter about optimization. CALCULATE with simple (Boolean) filters is ALWAYS preferred to FILTER due to internal optimizations. Simple as that.
Best
D
Best
D