I need to create a table with outlier values with below condition.
Outlier Table = [TTR] > (AVERAGE(TTR) + 3 * (STD(TTR)))
where TTR = EndTime - StartTime (It will be in Positve always, currently ignore those which have negative)
Hi @SantoshKumar ,
Calculated table is static once it has been initilized, it won't be dynamically changed based on slicer selection.
In your scenario, you need measures instead. Please refer to below measure, add it to "visual level filter", and set its value to 1.
Measure = VAR _average = CALCULATE ( AVERAGE ( 'TTR Table'[TTR] ), ALLSELECTED ( 'TTR Table' ) ) VAR _Stdev = CALCULATE ( STDEV.P ( 'TTR Table'[TTR] ), ALLSELECTED ( 'TTR Table' ) ) RETURN IF ( SELECTEDVALUE ( 'TTR Table'[TTR] ) > ( _average + 3 * _Stdev ), 1, 0 )
i have few question on your solution, probably i may be worng or i am getting it right. please correct me.
i need to apply the filter to Table: