Forum Discussion

emarc1's avatar
emarc1
Advocate II
9 years ago

Dynamically filtering erroneous data

Hello.   What is the best way to filter out erroneous data points?    Example data showing a single product's (filtered by a slicer) value over time:     It should look like this (with the...
DataInsights's avatar
DataInsights
Super User
3 years ago

emarc1,

 

I adapted the solution described in the link below (kudos to the author!).

 

https://bielite.com/blog/scale-down-outliers-power-bi/ 

 

1. Create calculated column:

 

Outlier = 
VAR vMean =
    AVERAGE ( Table1[Value] )
VAR vStdDev =
    STDEV.P ( Table1[Value] )
VAR vResult =
    IF ( Table1[Value] > ( vMean + vStdDev ), 1, 0 )
RETURN
    vResult

 

 

2. Create measure:

 

Sum of Value (no Outliers) = 
CALCULATE ( SUM ( Table1[Value] ), Table1[Outlier] = 0 )