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

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.