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.

Erokor's avatar
Erokor
Resolver II
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.