Average between a set of numbers filtered on a Unique ID and each occurrence of a specific name

[Dalton948]

Good Evening, 

I am in the process of trying to figure out how to get a duration Average where as the duration is already provided. My issue is getting the filter right as i need filter on each unique ID in a large table, grab each occurance of a name and its associated #(Duration), and then caluclate the average.

This is my query measure thus far,

Ticket Time AVG =

VAR _CurrentElement_ID = MAX('Fabled Metric Table'[id_sys_id])

VAR _tbl = FILTER(ALL('Fabled Metric Table'),'Fabled Metric Table'[id_sys_id]=_CurrentElement_ID & 'Fabled Metric Table'[value_metric_instance] = "TOC_OPS")

VAR _avg = AVERAGEX(_tbl,'Fabled Metric Table'[duration])

Return _avg

Here is the table i am trying to work on,

I have isolated to one unique ID there which is id_sys_id and am trying to get the duration average between all the instances that say TOC_OPS.

Welcoming any suggestions, thanks in advance.

[Dalton948]

This worked pretty well, i also forgot to change the duration column to whole numbers. Once i checked that and with your formula, it worked like a charm. Thanks for your help!

[Fowmy · Accepted solution]

@Dalton948 

Please try:

Ticket Time AVG =
VAR _CurrentElement_ID =
    MAX ( 'Fabled Metric Table'[id_sys_id] )
VAR __Result =
    CALCULATE (
        AVERAGE ( 'Fabled Metric Table'[duration] ),
        'Fabled Metric Table'[id_sys_id] = _CurrentElement_ID,
        'Fabled Metric Table'[value_metric_instance] = "TOC_OPS"
    )
RETURN
    __Result