Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Finding data points outside of 2 Standard Deviations

Hello,   I am currently trying to to find data points of a column called "EPG" which fall outside of 2 standard deviations to remove outliers.   to get the Average:  InternalEPGAvG = AVERAGE(Ph...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago
    +2Std = VAR StandardDev =
	CALCULATE(
		STDEV.P( 'PhenRQCJoinData'[EPG] ),
		REMOVEFILTERS( 'PhenRQCJoinData' )
	)
VAR OverallAverage =
	CALCULATE(
		[Internal Average],
		REMOVEFILTERS( 'PhenRQCJoinData' )
	)
VAR NumOver =
	COUNTROWS(
		FILTER(
			'PhenRQCJoinData',
			'PhenRQCJoinData'[EPG] > OverallAverage + StandardDev * 2
		)
	)
RETURN
	NumOver
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago
+2Std = VAR StandardDev =
	CALCULATE(
		STDEV.P( 'PhenRQCJoinData'[EPG] ),
		REMOVEFILTERS( 'PhenRQCJoinData' )
	)
VAR OverallAverage =
	CALCULATE(
		[Internal Average],
		REMOVEFILTERS( 'PhenRQCJoinData' )
	)
VAR NumOver =
	COUNTROWS(
		FILTER(
			'PhenRQCJoinData',
			'PhenRQCJoinData'[EPG] > OverallAverage + StandardDev * 2
		)
	)
RETURN
	NumOver
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks heaps, Worked well.