Forum Discussion
Find Resolution Percentage
Hi All,
I am very new in PowerBI. and I need to find Resolution %. So in excel I usually do, (Resolved tickets / (total tickets - Scheduled tickets).
Please help.
Mohit
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")
3 Replies
You will need to provide more Information. Please share your data structure, table names, columns etc.
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")
