Given the following formula’s
IncorrectMeasure =
VAR FilteredValue =
CALCULATE(
[SomeMeasure],
FILTER('SomeTable', 'SomeTable'[SomeColumn] = "SomeValue")
)
VAR FinalResult =
CALCULATE(
FilteredValue,
FILTER('AnotherTable', 'AnotherTable'[AnotherColumn] = "AnotherValue")
)
RETURN FinalResult
IntermediateMeasure =
CALCULATE(
[SomeMeasure],
FILTER('SomeTable', 'SomeTable'[SomeColumn] = "SomeValue")
)
CorrectMeasure =
CALCULATE(
IntermediateMeasure,
FILTER('AnotherTable', 'AnotherTable'[AnotherColumn] = "AnotherValue")
)
Why do IncorrectMeasure
and CorrectMeasure
have different results? It seems that the filter in VAR FinalResult
is not being honored.