True SLA Percentage by customer wise

[sivaksk147]

Hi Team,

I am looking for some help to create a DAX formula for achieving the only True SLA percentage by customer wise. 

I have tried multiple solutions it's not working. appreciate your help.

Find the sample content for your reference

Customer	Ticket ID	SLA
A	1456	FALSE
A	1457	TRUE
A	1458	FALSE
A	1459	FALSE
B	1460	TRUE
B	1461	TRUE
B	1462	FALSE
B	1463	FALSE
C	1464	TRUE
C	1465	TRUE
C	1466	TRUE
C	1467	FALSE

[Fowmy · Accepted solution]

@sivaksk147 

Add the following measure to a table visual where you have your customers:

TRUE SLA % = 
IF(
    HASONEVALUE(Table12[Customer]),
    DIVIDE(
        CALCULATE( COUNTROWS(Table12), Table12[SLA] = TRUE() ),
        COUNTROWS(Table12)
    )
)

[sivaksk147]

Thank you very much for your support. the solution worked as I desired.  

[HashamNiaz]

Hi @sivaksk147 !

Please post the desired output as well. How you want to calculate SLA percentage a business description.

Regards,

Hasham