Adding SWITCH for Average Call Time and Average Hold Time

Hi jabueg 

Updated AverageCallDuration with SWITCH:

AverageCallDuration =
VAR TotalSeconds =
    SWITCH(
        TRUE(),

        // Case 1: Single Advisor AND Single Date selected
        HASONEVALUE(UpdatedProd521[Advisor]) && HASONEVALUE(UpdatedProd521[Date]),
        CALCULATE(
            AVERAGE('Combined Call Logs 5/17'[CALL TIME (SEC)]),
            USERELATIONSHIP(UpdatedProd521[Advisor], 'Combined Call Logs 5/17'[ADVISOR]),
            FILTER(
                'Combined Call Logs 5/17',
                'Combined Call Logs 5/17'[DATE] = VALUES(UpdatedProd521[Date])
            )
        ),

        // Case 2: Only Advisor is selected
        HASONEVALUE(UpdatedProd521[Advisor]),
        CALCULATE(
            AVERAGE('Combined Call Logs 5/17'[CALL TIME (SEC)]),
            USERELATIONSHIP(UpdatedProd521[Advisor], 'Combined Call Logs 5/17'[ADVISOR])
        ),

        // Case 3: Only Date is selected
        HASONEVALUE(UpdatedProd521[Date]),
        CALCULATE(
            AVERAGE('Combined Call Logs 5/17'[CALL TIME (SEC)]),
            USERELATIONSHIP('Combined Call Logs 5/17'[DATE], UpdatedProd521[Date])
        ),

        // Default: average over all call times if no or multiple selections
        AVERAGE('Combined Call Logs 5/17'[CALL TIME (SEC)])
    )

VAR Minutes = INT(TotalSeconds / 60)
VAR Seconds = MOD(TotalSeconds, 60)

RETURN
    IF(TotalSeconds = 0,
       "0 min",
       FORMAT(Minutes, "0") & " min, " & FORMAT(Seconds, "0") & " sec"
    )

Updated Avg Hold Time with SWITCH:

AvgHoldTime =
VAR TotalSeconds =
    SWITCH(
        TRUE(),

        // Case 1: Single Advisor AND Single Date selected
        HASONEVALUE(UpdatedProd521[Advisor]) && HASONEVALUE(UpdatedProd521[Date]),
        CALCULATE(
            AVERAGE('Combined Call Logs 5/17'[HOLD TIME (SEC)]),
            USERELATIONSHIP(UpdatedProd521[Advisor], 'Combined Call Logs 5/17'[ADVISOR]),
            FILTER(
                'Combined Call Logs 5/17',
                'Combined Call Logs 5/17'[DATE] = VALUES(UpdatedProd521[Date])
            )
        ),

        // Case 2: Only Advisor is selected
        HASONEVALUE(UpdatedProd521[Advisor]),
        CALCULATE(
            AVERAGE('Combined Call Logs 5/17'[HOLD TIME (SEC)]),
            USERELATIONSHIP(UpdatedProd521[Advisor], 'Combined Call Logs 5/17'[ADVISOR])
        ),

        // Case 3: Only Date is selected
        HASONEVALUE(UpdatedProd521[Date]),
        CALCULATE(
            AVERAGE('Combined Call Logs 5/17'[HOLD TIME (SEC)]),
            USERELATIONSHIP('Combined Call Logs 5/17'[DATE], UpdatedProd521[Date])
        ),

        // Default: average over all hold times if no or multiple selections
        AVERAGE('Combined Call Logs 5/17'[HOLD TIME (SEC)])
    )

VAR Minutes = INT(TotalSeconds / 60)
VAR Seconds = MOD(TotalSeconds, 60)

RETURN
    IF(TotalSeconds = 0,
       "0 min",
       FORMAT(Minutes, "0") & " min, " & FORMAT(Seconds, "0") & " sec"
    )

• The SWITCH(TRUE()) block checks slicer selections on Advisor and Date to decide which relationship or filter to apply.
• USERELATIONSHIP activates the inactive relationship for filtering.
• When both Advisor and Date are selected, it filters for that date as well.
• Default case averages over all call or hold times without filter.
• The result formats seconds into "minutes and seconds" or shows "0 min" if zero.
•