Forum Discussion
Find Resolution Percentage
so you need to build the three interim measures you need
Resolved tickets / (total tickets - Scheduled tickets
Something like this. I don't know the logic you use to count the tickets, but here is one way (assuming each row is a ticket)
Resolved tickets = calculate(countrows(ticketTable),Pending="Resolved")
I have huge data in which there are some ticket's status is Scheduled (Mentioned in column name 'Pending'). I have one column where mention ticket is resolved or open status as well. so I need to find Resolution % and I use Formula to find it in excel is - (Resolved tickets / (total tickets - Scheduled tickets). So in excel I usually do - (Resolved tickets[2500] / (total tickets[3000] - Scheduled tickets[200]). How can I find in PowerBI.
so you need to build the three interim measures you need
Resolved tickets / (total tickets - Scheduled tickets
Something like this. I don't know the logic you use to count the tickets, but here is one way (assuming each row is a ticket)
Resolved tickets = calculate(countrows(ticketTable),Pending="Resolved")