Use of Variables and Measures for FILTER

[AntrikshSharma]

@swong12

Max(Date[Date]) measure used in the filter function

@fudzen88 When you use the measure branching technique you are calling a measure in the row context inside FILTER, a measure always has an invisible CALCULATE wrapped around it so the code that you think is same isn’t actually same, your first code looks something like this to the DAX Engine: FILTER ( ALL ( Dates ), Dates[Date] <= CALCULATE ( MAX ( Dates[Date] ) ) ) [image] Calculate converts each row into Filter Context that defines what MAX would return. For each cell of the below…

Dependency Of A Function On Row Context In DAX Explained With DAX Studio