Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

SLA calculation by month.

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

 

Need Help
  • OwenAuger's avatar
    OwenAuger
    7 years ago

    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

2 Replies

  • OwenAuger's avatar
    OwenAuger
    Icon for Super User rankSuper User
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      OwenAuger

       

      Thanks For the quick reply. 

       

      It works as expected if I use the correct visualization.

       

      Thanks