Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Context Transition Different with Measure Reference Even with CALCULATE

Hi, I'm struggling to grasp why I'm experiencing the following.   When I use a reference to Measure_1 (which begins with CALCULATE) in Measure_2, I get one result. When I simply copy the text from ...
CALCULATE
context transition
measure
VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi Anonymous 

 

Change VALUES in the Measure 1 to MAX and try that.

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi VahidDM , thanks for your quick reply.

 

Week_ID is a text-column ("week 1", "week 2" etc.).

 

I'm more interested in learning why the result is different when CALCULATE is present in both methods; I was expecting the context-transition to be the same.

 

Do you know why the results are different?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      VahidDM, thank you for referring me to this.

       

      Unfortunately, while it's a helpful article, it does not address my original question. I understand that variables are evaluated in their original context.

       

      The question, in essence, is why the two versions of Measure_2 above would yield different results. They both involve CALCULATE, so the same context transition should be ocurring.