Deleted Tasks are counted In Created count

I’ve written a measure for the Task Completeness. No of Tickets Resolved / No of Tickets Created is formula used in that.

CASE WHEN [Measures].[Issues created] > 0
THEN
CoalesceEmpty([Measures].[Issues resolved],0)/
[Measures].[Issues created]
END

In that I’ve deleted a sub-task. and all the remaining 10 sub-tasks I’ve closed.
I’m getting the percentage as 91%. while checking the count values individually observed like below

Total No of Tasks created : 11
Total No of Tasks resolved : 10

How we can ignore the deleted sub-task

Any leads will be appreciated

Hi @Tony_Thomas,

​Can you please advise if you imported data again into eazyBI after you deleted the sub-task?

​Best wishes,
​Elita from support@eazybi.com