Hi,
I think you have Application Insights sampling enabled. In such case some similar requests (even failed ones) will be put into single record in the table. Each record in the requests table will have column itemCount with certain value. So when you count the records you need to count the sum of itemCount. For example:
requests
| summarize count(itemCount)
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.