MS Excel Toronto Meetup - What is the DAX CALCULATE Function and how does it work -Wyn Hopkins

Excellent presentation Wyn. I will look at purchasing your book.

So useful! Thanks for sharing

Excellent! Thanks, Wyn and Celia.

I think people struggle to understand CALCULATE function, because of its syntax. It would have been much better to have first as parameters all possible filters to be applied, and then the expression to be the last parameter. This is most probably how our brains function, but for CALCULATE it is exactly in the opposite order. Do you agree ?

Awesome tutorial! Thank you, Wyn and Celia.

Getting a weird error message on the measures. ‘Something about referencing multiple instances’
I then did a calculate(sum(filter())) method in the measure formulas which cleared the errors but now I’m getting an error when trying to move the measures into the values field: ‘cannot convert of type text to type try/false’ (which is indicating based on my customer code field)

Any pointers?