All data points for drives having exceeded a threshold at some time

[lesnalder]

Hi,

I have a daily data set from several hundred hard drives showing the free space for which I getting the daily movement in percentage points. As most of the movement is very small (within 1-2% points) I'd like to show only the values for those drives with more dynamic movement i.e. abs(Movement)>2%. I've been able to create a measure which shows only those data points above the threshold but what I'd like to do is show all data for those drives which have crossed this threshold at some time.

[lesnalder · Accepted solution]

I have worked out a solution. I've created a calculated table using a filter which determines which drives have the greater movement. Then used measures on the calculated table.