Skip to main content

DAX Measure to calculate % of tickets closed within TAT

 %TICKETS_CLOSED_WITHIN_TAT(%Success) =

VAR FilteredTable =
    FILTER(
        'Closed,Rejected',
        'Closed,Rejected'[TAT_Closed_Req] = "Within TAT" //[TAT_Closed_Req] Is a measure
    )
RETURN
DIVIDE(
    CALCULATE(COUNT('Closed,Rejected'[Id]), FilteredTable),
    CALCULATE(COUNT('Closed,Rejected'[Id]))
)




Labels:

Comments

Post a Comment

Popular posts from this blog

Convex Lens Vs Concave Lens

What is a Lens A lens is a transparent object that transmits light across it, and its working principle depends on the   law of refraction (Snell’s law) . Applications: Concave Lens help with Far-Sight Convex Lens help with Near-Sight
Post a Comment
Read more

Herbal Plants

Herbal plants to grow in home Different types of keerai ----- http://www.indiandietrecipes.com/2016/03/pictures-of-various-types-of-greens-or.html Pirandai ----good for bone joins---- https://youtu.be/k2DGubyXLAE Valarai Keerai Benifits ----- https://youtu.be/33HIfLJKTqA Sesma seeds ---- https://easyayurveda.com/2011/02/24/sesame-and-sesame-oil-benefits-total-ayurveda-details/
4 comments
Read more

What is Verbal and Non-Verbal communication

TYPES OF COMMUNICATIONS:
Post a Comment
Read more