Forum Discussion

SergioHB's avatar
SergioHB
Helper I
6 years ago
Solved

SLA Achivement Calculation

Hi guys,   I'm starting with PowerBI and DAX and would like if some could give me a hand on the following. I'm creating a dashboard to follow-up SLA achivement depending on priorities but I don't k...
Need Help
Show and Tell
Tips and Tricks
  • Icey's avatar
    Icey
    6 years ago

    Hi SergioHB ,

    Is this what you want? This is my PBIX file.

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

SergioHB's avatar
SergioHB
Helper I
6 years ago

Thank Icey ,

 

I'll check this along the day but looks fine to me. Only one last question. 

 

The column 'Closed' is just counting cases from the period, but what if the cases were created in the past and closed now?

 

Example:

 

In September there are 150 cases logged and from those 140 closed, so 10 pending. That does not mean that in September only 140 cases are closed, there can be closed cases from past months (previous backlog). There can be more closed than logged cases.

 

Do you get my point? I don't think this has been taken in consideration when you define the 'Closed' column.

 

Thanks

 

 

 

SergioHB's avatar
SergioHB
Helper I
6 years ago

Hi Icey 

 

No reply to my last email. Did you have a chance to have a look at it?

 

Thanks

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi SergioHB ,

    Sorry to reply late. You can create a column:

    Month of CreatedDate = MONTH ( 'Table'[CreatedDate] )

    Then, you can create your "Closed" measure like so:

    Closed =
CALCULATE (
    COUNT ( 'Table'[ClosedDate] ),
    ALLSELECTED ( 'Table'[Month of CreatedDate] )
)

    If your created years are also different, you can create a column of Created Year too. And then, add it into "Closed" measure.

     

    Best Regards,
    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.