I am relatively new to PowerBI, I want to calculate the Standard Deviation of a parameter eg: Temperature for each batch based on different filters. This standard deviation has to be calculated by a measure and it has to be displayed in a Card But I need to eliminate outliers before calculating std deviation. How can I Do it in measure?
Outliers condition is Values greater than 99 percentile and less than 1 percentile to be considered as outliers
