Solved: Calculate function: in which order the filters app...

PaulDBrown · ‎03-09-2018

If the function conains several filters, in which order are they applied? Does it make a difference?

thanks,

Paul

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

Ashish_Mathur · ‎03-09-2018

Hi.

No, Since all filer conditions in the CALCULATE() function are and conditions, the order does not matter.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Ashish_Mathur · ‎03-09-2018

Hi.

No, Since all filer conditions in the CALCULATE() function are and conditions, the order does not matter.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Calculate function: in which order the filters applied