Presenting SLA performance with Gauge

[bahare76]

Dear all,

I need to produce a visual using the Gauge indicator. The sample data which i have is as follows:

Ticket ID	Requester	Status Overdue
1234	James	False
2345	Arren	False
3456	Alice	False
4567	John	True
5678	Donna	False
6789	Monica	True

As you can see, the column ' Status Overdue' is in Boolean Type (True or False). I just wanted the gauge to indicate the SLA performance in percentage. The calculation is total number of ticket with status overdue as "False" divided by total number of ticket * 100. 

Many thanks for your help.

BS

[amitchandak]

@bahare76 , Try a measure like

divide(calculate(count(Table[Ticket ID]), filter(Table,Table[Status] ="False")), count(Table[Ticket ID]))

[bahare76]

Hi @amitchandak . Tried this but encountered erro. Do i need to change the data type to Text first. Here is the expression

Measure = DIVIDE(CALCULATE(COUNT('Monthly Data'[Request ID]),FILTER('Monthly Data','Monthly Data'[Overdue Status] ="false")), COUNT('Monthly Data'[Request ID]))

[amitchandak · Accepted solution]

@bahare76 , if false is boolean 

Measure = DIVIDE(CALCULATE(COUNT('Monthly Data'[Request ID]),FILTER('Monthly Data','Monthly Data'[Overdue Status] =false())), COUNT('Monthly Data'[Request ID]))

[amitchandak · Accepted solution]

Measure = DIVIDE(CALCULATE(COUNT('Monthly Data'[Request ID]),FILTER('Monthly Data','Monthly Data'[Overdue Status] =false())), COUNT('Monthly Data'[Request ID]))