Can you explain your requirement a little more ?
You have table called Failure which lists items (which may fail, I guess).
You have another table which counts the Failures. If I select a Failed item, I seem to get the correct count - do you not agree ? Can you suggest an item which has had no failures, but which shows a value for the count ?
You may also want to review your table links - QlikView has automatically created synthetic keys, but it is usually advised that your data is managed in a way to avoid this. There is some useful information in the documentation on this.
Hope this helps.