Calculate % of tickets responded to in time

DAX DAX Calculations
6

Hello @seunao,

Thank You for posting your query onto the Forum,

Try this measures -

1). % Of Responses Recorded In Time -

% Of Responses Recorded In Time = 
VAR _Total_No_Of_Responses = 
CALCULATE( COUNTROWS( Data ) , ALL( Data ) )

VAR _No_of_Responses_In_Time = 
IF(
    DATEDIFF( 
        SELECTEDVALUE( Data[Opened Date] ) + SELECTEDVALUE( Data[Opened Time] ) , 
        SELECTEDVALUE( Data[First Contact Date] ) + SELECTEDVALUE( Data[First Contact Time] ) , 
        MINUTE ) < 45 , 
    1 , 
    0
)

VAR _Percentage_of_Responses_Recorded_In_Time = 
DIVIDE( _No_of_Responses_In_Time , _Total_No_Of_Responses , 0 )

RETURN
_Percentage_of_Responses_Recorded_In_Time

And than to fix the grand total write another simple small measure. One of our expert @Greg has already created a post that address this specific issue. Below is the link of the post provided for the reference as well.

2). % Of Responses Recorded In Time - Totals

% Of Responses Recorded In Time - Totals = 
SUMX(
    SUMMARIZE(
        Data , 
        Data[Incident Number] , 
        "@Totals" , 
        [% Of Responses Recorded In Time] ) , 
    [@Totals]
)

Below is the screenshot of the final results provided for the reference -

Final Results
Final Results1220×435 27.7 KB

I’m also attaching the working of the PBIX file for the reference.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

% of Responses Recorded In Time - Harsh.pbix (21.3 KB)

5 Likes