Forum Discussion

sunilbeckham's avatar
sunilbeckham
Helper I
2 years ago
Solved

Calculate function not filtering when a variable is used.

Hello everyone. I have a table that looks something like this: School Division Student enrollment Month A 10 Oct B 12 Oct C 15 Nov C 10 Dec   When I create a simple...
  • Erokor's avatar
    Erokor
    2 years ago

    Echoing Greg_Deckler on this one, but with a little more information. Variables are calculated only once and then stored only once and cannot be re-used in their current context. The only exception to this is if you create a variable that is a table: 
    ie. VAR _SourceTable = FILTER(ALL('Date'[Year]),'Date'[Year]>=2010) 
    and then later on you want to further filter this source table ie. VAR _MoreFiltering = FILTER(_SourceTable, [Year] >= 2013).

    Measures are calculated in the current filter context (sometimes that's okay if you want to keep the value static) but you can't use CALCULATE() to adjust that after the fact.