Why do you need change context with calculate when using a measure


#1

Hi Sam,

In the formula below, Why did you need to change the context when a measure is in place automatically activating filter context. I understand why you placed the ALL function to calculate % of total sales to ignore filter context.


Thanks
Elizabeth Tachjian


#2

Elizabeth,

What CALCULATE does is change the evaluation context (filter) on the expression.

Explained very well here:

Guy


#3

Yes makes sense.