I am trying to do some statistical anlaysis of network performance data. The key attribute I would like to do the analysis on is called values. Within values are positive whole integers. Thus far, I can get the min, max, average, and standard deviation. Through a lookup table, I am able to calculate a value depending on how many standard deviations one is away from the average.
What I would like to be able to do, is for a given standard deviation value, count how many data points are above that value. I have tried many different methods to do this, but I keep hitting a wall and cannot get it to work.
Here is what my current overview tab looks like. for the CutoffValues, I would like to get a sense of how many rows have values greater than the cutoffvalues.
The measure Z is computed by:
Z = sum('myTable'[values])-AVERAGE('myTable'[values])/stdev.p('myTable'[values])
CutoffValues = (stdev.p('myTable[values])*sum(SD[SDs to enumerate through])+AVERAGE('myTable'[values]))
[SDs to enumerate through] is just a custom table with values 1 through 10