SLA calculation by month.

[Anonymous]

Hello to all

This is probably a easy one.

I have a column that calculates the if a specific item meets the SLA defined. In my case 0 for no 1 for yes and for each item the month for that SLA achieved.

Now I want the SLA % by month but I'm getting 100%... always. 😞

My table is something like:

SLA  Month

1         January

0         January

0         January

1         January

0         February

0          February

1          February

0         March

0          March

1          March

So SLA % for January should be 50%, both others should be 33%.

How can I get the correct value?

Thanks

[OwenAuger · Accepted solution]

@Anonymous

We can sum the SLA column to get the number of times SLA was achieved, then divide that by the number of rows to get the SLA %.

A measure like this should work:

SLA % =
DIVIDE (
    SUM ( YourTable[SLA] ),
    COUNTROWS ( YourTable )
)

 Regards,

Owen

[Anonymous]

@OwenAuger

Thanks For the quick reply. 

It works as expected if I use the correct visualization.

Thanks