calculate cycle times, get an average excluding top 15%
In a manufacturing setting I have a pick started and pick completed time/date stamps, i have subtracted them from one another to get the duration or cycle time. I am trying to build a report to get the average which i did using a measure however my data is skewed due to some outlier times and i would like to exclude the top 15% without removing the data. I know i can do it with if functions within excel but i am racking my brain with DAX.
