Find Resolution Percentage

[mmohit]

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

[MattAllington]

You will need to provide more Information.  Please share your data structure, table names, columns etc. 

[mmohit]

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.

[MattAllington · Accepted solution]

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")