How to calculate the mean of specific values of time

[Anonymous]

Hi all,

I explain my situation:

I have this matrix:

Where I minimize selecting the greatest values in black in the next table.

From the matrix where I have selected the maximum values for T max, TG max and times (not maximum, the most recent), I would like to show in the table on the right the mean  of the REACH Y value (time) between the component 32 and 64 (shown in green colour).

For Tmax mean between 83,66 and 107.33 -> 95.5

For Tgmax mean between 78.45 and 81.61 -> 81.61

For Tmax and Tgmax we have followed these steps:

-Select the calculation -> Promedio por categoría (Mean by category)

-Select the values for the calculations -> Tmax and TGmax -> The maximum (max.)

-Select the category -> Recipe (R1)

If I try to do the same with values for time, the system only allows me to select the values as COUNT of time... but I would like to choose the values that are the green values in the first screenshot.

So the result that I want should be the mean of 6:33:59 and 4:41:56. ( that are the greates values of its group)

Thanks to all

[Anonymous · Accepted solution]

Hi @Anonymous ,

According to my understand, you want to calculate the average of time ,right?

You could use the following formula:

average time =
VAR _ave =
    CALCULATE (
        AVERAGEX (
            'Table',
            HOUR ( [Reach.x] ) * 60 * 60
                + MINUTE ( [Reach.x] ) * 60
                + SECOND ( [Reach.x] )
        )
    )
VAR _h =
    TRUNC ( ( _ave ) / 3600 )
VAR _m =
    TRUNC ( MOD ( _ave, 3600 ) / 60 )
VAR _s =
    TRUNC ( MOD ( _ave, 60 ) )
RETURN
    TIMEVALUE ( _h & ":" & _m & ":" & _s )

 My visualization looks like this:

Here is the pbix file.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin