where clause after limiting results
Thank you Akina for the tip, got it working using the following query

SELECT 
      COUNT(measurement) as 'Measurement Errors'
     FROM ( 
        SELECT *
        FROM measurelog
        ORDER BY Id DESC
        LIMIT 100
        ) sub
    WHERE (measurement &lt; (baseline - tolerance))


which now returned 7 results