Forum Discussion

Noak's avatar
Noak
Helper IV
9 years ago

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...
General Comment
Need Help
Tutorial Requests
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago

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.

  • Noak's avatar
    Noak
    Helper IV
    9 years ago

    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
    • Eric_Zhang's avatar
      Eric_Zhang
      Microsoft Employee
      9 years ago
      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?

      • Noak's avatar
        Noak
        Helper IV
        9 years ago
        @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?