Forum Discussion
hideakisuzuki01
Helper II
3 years agoNeed help understanding Context Transition
Hi, I have below two tables (Fact and ProductDim) Fact ProductDim Product Sales Product SalesPerson A 100 A James A 200 B Chris B 300 C Steve B...
jdbuchanan71
Super User
3 years agoNo, measure 3 has a filter context. Context transition takes a row context and converts it to a filter context. Filter context is the more common context in models. Row context comes in when you are iterating over a table (calculated columns, SUMX, AVERAGEX, etc) and that is where you need the context trasition forced by CALCULATE or the hidden CALCULATE on an exising measure.