Forum Discussion
Filter matrix by standard deviation
Hi Is there a way I can filter my results in a matrix using standard deviation? For example my matrix has numerical values in the columns going down, and I would like to make blank the values whi...
Hi Anonymous ,
Is this what you want?
Measure = VAR sd_AvgMileage = CALCULATE ( STDEV.P ( 'Table'[Avg Mileage] ), ALLSELECTED ( 'Table' ) ) RETURN IF ( MAX ( 'Table'[Avg Mileage] ) > sd_AvgMileage + 2 || MAX ( 'Table'[Avg Mileage] ) < sd_AvgMileage - 2, BLANK (), MAX ( 'Table'[Avg Mileage] ) )Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sure here is an example. I have two columns, there are also rows which correspond to each row which are car registeration plates. Both of these columns go into the 10,000s in terms of length. I want to calculate the standard deviation for each column, and then have the data values which exceed 2 times the standard deviation to be converted to BLANK for each column.
- Icey
Community Support
Hi Anonymous ,
Is this what you want?
Measure = VAR sd_AvgMileage = CALCULATE ( STDEV.P ( 'Table'[Avg Mileage] ), ALLSELECTED ( 'Table' ) ) RETURN IF ( MAX ( 'Table'[Avg Mileage] ) > sd_AvgMileage + 2 || MAX ( 'Table'[Avg Mileage] ) < sd_AvgMileage - 2, BLANK (), MAX ( 'Table'[Avg Mileage] ) )Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.