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
Noak
Helper IV
Helper IV

Accumolate exceeding cases

Hey everyone,

I have new mission and need your help .

 

My data based on open cases that divided to seveirties(1 high - 3 low), the CTO defindes cases SLA eg: if case defined as high the resolving time of that specific case is no longer than 24 days. It's a binaric situation in case we exceeded that period IsExceeding=1. in case we didn't it will be 0.

 

I need to present accumolate exceeding cases per month - stacked column chart that presents 3 layers of the severities.

 

Here's what I did,

 Capture2.PNG

 

 

As you can see what happened here is that if in total i have 102 exceeding cases the chart shows how much belongs to each month and doesnt shows me accumolate cases.

 

I mean I need to see in fabruary 2017 overall view of how much cases is exceeding until 31.2.17 - is should sum all open exceeding cases for last X months and shows how much did it collect until the 31.2 and divide it to severity type (high-low).

 

here's my data:

 Capture3.PNG

 

 

BR,
Noa.
4 REPLIES 4
Eric_Zhang
Employee
Employee

@Noak

Your requirement is not quite clear for me. Based on my understanding, it looks that you're looking for a measure like 

 

Acc exceeding cases =
COUNTROWS (
    FILTER (
        yourTable,
        yourTable[createon] <= MAX ( yourTable[createon] )
            && yourTable[isExceed] = 1
    )
)

By the way, could you please post the sample data in plain text, the picture doesn't help too much.

Hi @Eric_Zhang

I already used this messaure.

 

It doesnt answer my dashboard needs, lets say today we have 100 exceeding cases that are still open.

I want to see the trend in monthly view,

 

current result = power bi takes 100 cases spred them by the creation month and give me a view of how many exceeding case from january,feb,march.... I dont care how much from each month I care to see the trend over time.

 

heres a glanss of the data:

createdonAcc exceeding casesseveritycodename
29/02/2016 15:031Severity 2 - Medium
15/03/2016 08:561Severity 2 - Medium
18/03/2016 14:161Severity 3 - Low
18/03/2016 14:471Severity 2 - Medium
14/04/2016 12:501Severity 2 - Medium
15/04/2016 08:251Severity 2 - Medium
22/04/2016 08:511Severity 2 - Medium
06/05/2016 14:261Severity 2 - Medium
09/05/2016 15:201Severity 2 - Medium
16/05/2016 10:551Severity 2 - Medium
16/05/2016 10:591Severity 3 - Low
16/05/2016 11:051Severity 2 - Medium
17/05/2016 13:271Severity 2 - Medium
30/05/2016 05:041Severity 2 - Medium
30/05/2016 05:371Severity 2 - Medium
02/06/2016 13:161Severity 2 - Medium
03/06/2016 14:281Severity 2 - Medium
06/06/2016 15:421Severity 2 - Medium
07/06/2016 08:331Severity 2 - Medium
08/06/2016 12:291Severity 2 - Medium
08/06/2016 12:351Severity 2 - Medium
09/06/2016 12:381Severity 2 - Medium
10/06/2016 07:431Severity 2 - Medium
14/06/2016 11:431Severity 2 - Medium
15/06/2016 09:331Severity 2 - Medium
21/06/2016 07:391Severity 2 - Medium
21/06/2016 14:191Severity 1 - High
24/06/2016 10:311Severity 2 - Medium
27/06/2016 10:231Severity 2 - Medium
27/06/2016 10:291Severity 2 - Medium
29/06/2016 14:571Severity 2 - Medium
29/06/2016 14:591Severity 1 - High
30/06/2016 07:311Severity 1 - High
30/06/2016 10:461Severity 1 - High
30/06/2016 18:331Severity 2 - Medium
30/06/2016 19:501Severity 2 - Medium
04/07/2016 09:461Severity 2 - Medium
05/07/2016 09:261Severity 2 - Medium
08/07/2016 09:111Severity 1 - High
08/07/2016 09:281Severity 2 - Medium
11/07/2016 14:391Severity 2 - Medium
11/07/2016 14:441Severity 3 - Low
19/07/2016 18:111Severity 1 - High
20/07/2016 19:251Severity 2 - Medium
21/07/2016 07:101Severity 2 - Medium
22/07/2016 12:501Severity 2 - Medium
22/07/2016 13:212Severity 2 - Medium
23/07/2016 16:101Severity 2 - Medium
27/07/2016 08:251Severity 2 - Medium
27/07/2016 09:031Severity 2 - Medium
27/07/2016 15:111Severity 2 - Medium
29/07/2016 13:071Severity 2 - Medium
29/07/2016 13:511Severity 2 - Medium
29/07/2016 14:001Severity 2 - Medium
29/07/2016 14:081Severity 2 - Medium
01/08/2016 11:191Severity 2 - Medium
01/08/2016 11:331Severity 2 - Medium
02/08/2016 13:291Severity 2 - Medium
03/08/2016 21:301Severity 2 - Medium
08/08/2016 21:221Severity 2 - Medium
10/08/2016 15:391Severity 2 - Medium
17/08/2016 20:391Severity 2 - Medium
22/08/2016 13:481Severity 2 - Medium
26/08/2016 19:471Severity 2 - Medium
09/09/2016 10:131Severity 2 - Medium
13/09/2016 10:541Severity 3 - Low
14/09/2016 09:231Severity 1 - High
19/09/2016 11:091Severity 2 - Medium
19/09/2016 19:231Severity 2 - Medium
21/09/2016 19:211Severity 2 - Medium
22/09/2016 09:421Severity 2 - Medium
23/09/2016 09:251Severity 2 - Medium
27/09/2016 15:311Severity 2 - Medium
BR,
Noa.


@Noak wrote:

Hi @Eric_Zhang

I already used this messaure.

 

It doesnt answer my dashboard needs, lets say today we have 100 exceeding cases that are still open.

I want to see the trend in monthly view,

 

current result = power bi takes 100 cases spred them by the creation month and give me a view of how many exceeding case from january,feb,march.... I dont care how much from each month I care to see the trend over time.

 


What do you mean a trend then? May be a increasing or dropping percentage of each month?


@v-lvzhan-msft wrote:

 What do you mean a trend then? May be a increasing or dropping percentage of each month?

 


I mean if increasing @Eric_Zhang. do you have any solution for that?

BR,
Noa.

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.