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