Forum Discussion

Pinky0404's avatar
Pinky0404
Helper III
8 years ago

Calculate Ticket SLA

Hi All,   I’ve been requested to calculate the  tickets SLA  by  adding all the open tickets and tickets closed in last 30 days. I have columns "Date closed" and  "Ticket Status(inprogress, open, c...
Need Help
Pinky0404's avatar
Pinky0404
Helper III
8 years ago

I feel like i got the soultion. But not sure if it is the right way to do.

 

Created the below DAx:

 

1)ALL Open = IF(Footprint[New status]<>"Closed",Footprint[SO])

 

2)Closed in LAst 30 days = IF((Footprint[Date Closed]> Footprint[RD]-30) && (Footprint[Date Closed]<=Footprint[RD]),"Closed 30 days","Null")

 

3)Days - Closed(30 days) = IF(Footprint[Closed in LAst 30 days] = "Closed 30 days",Footprint[SC])

 

4)SLA Final = IF(ISBLANK(Footprint[ALL Open]),Footprint[Days - Closed(30 days)],Footprint[ALL Open])

 

Output:

 

 

 

 

Please let me know if i can achieve this in a more better way.

 

Thanks,

Pinky

 

ChandeepChhabra's avatar
ChandeepChhabra
Impactful Individual
8 years ago

Hi Pinky0404,

 

Looks like you have created a lot of calculated columns. Found a bracket is missing in one of your measures

 

2)Closed in LAst 30 days = IF((Footprint[Date Closed]> (Footprint[RD]-30)) && (Footprint[Date Closed]<=Footprint[RD]),"Closed 30 days","Null")

 

Can you share your pbix file, I'll be able to write a measure that does the same

  • Pinky0404's avatar
    Pinky0404
    Helper III
    8 years ago

    Please share me your email id.