Mean Period Change Excl Current = VAR _CurrentPeriod = SELECTEDVALUE ( <>[<>] ) VAR _ChangesForContext = FILTER ( ADDCOLUMNS ( ALL ( <>[<>] ), "@Change", [Period Change] ), NOT ISBLANK ( [@Change] ) && <>[<>] <> _CurrentPeriod ) RETURN AVERAGEX ( _ChangesForContext, [@Change] ) StdDev Period Change Excl Current = VAR _CurrentPeriod = SELECTEDVALUE ( <>[<>] ) VAR _ChangesForContext = FILTER ( ADDCOLUMNS ( ALL ( <>[<>] ), "@Change", [Period Change] ), NOT ISBLANK ( [@Change] ) && <>[<>] <> _CurrentPeriod ) RETURN STDEVX.S ( _ChangesForContext, [@Change] )