Forum Discussion

mmohit's avatar
mmohit
Frequent Visitor
9 years ago
Solved

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
Need Help
  • MattAllington's avatar
    MattAllington
    9 years ago

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