Forum Discussion
Kerry_M
Helper II
Helper IIWhy does result change when using VAR vs MEASURE in another measure?
I am curious as to why a formula using a measure caculates differently from a formula using a VAR with the exact same definition as the measure. There must be something different about the way VAR ar...
My guess is context transition caused by the hidden calculate inside a measure.
Try wrapping the var code min(order[orderdate]) in a calculate, as calculate(min(order[orderdate]))
context transition is a big and complex topic
MattAllington
Community Champion
Community ChampionMy guess is context transition caused by the hidden calculate inside a measure.
Try wrapping the var code min(order[orderdate]) in a calculate, as calculate(min(order[orderdate]))
context transition is a big and complex topic
Kerry_MThanks so much Matt. That worked perfectly!