Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

 

1 ACCEPTED SOLUTION
OwenAuger
Super User
Super User

@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


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

View solution in original post

2 REPLIES 2
OwenAuger
Super User
Super User

@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


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn
Anonymous
Not applicable

@OwenAuger

 

Thanks For the quick reply. 

 

It works as expected if I use the correct visualization.

 

Thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.