Percentage calculation of tickets which have escalated for a specific time frame

[ebelange]

Hi Everyone, 

I apologize, i'm fairly new to PowerBI and I'm setting my KPIs for an IT department that i manage. One of our KPI shows the percentage of tickets that were closed under the SLA period. 

What i'd like to display is a bar graph which shows the percentage for each month.

I have a field which tells me when a ticket was esacalated  (1 = escalated and 0 = not escalated) so all i need to figure out is how to create my graph to show me the wanted outcome.

% of TotalTickets Closed under SLA = (Sum of Totaltickets - sum of escalated tickets) / Sum of Totaltickets * 100

And I'll need to display these by month.

Is this doable?

[amitchandak]

@ebelange , Try measures like (Three measures)

Total Tickets = calculate(count(Table[Ticket]))
Escalated Tickets = calculate(count(Table[Ticket]), filter(Table,table[escalated]=1))

% of TotalTickets Closed under SLA = divide([Total Tickets] - [Escalated Tickets],[Total Tickets]) // You can mark at % column , no need multiply by 100

[Greg_Deckler]

@ebelange - Should be along the lines of:

Measure =
  VAR __AllMonth = COUNTROWS(ALLSELECTED('Table'))
  VAR __CurrentMonth = COUNTROWS(FILTER(ALLSELECTED('Table'),[Column]=1))
RETURN
  (__AllMonth - __CurrentMonth) / __AllMonth * 100

Probably don't need the 100 if you use the % display format.