Adding Certain Rows from a Summary Table

[antel1]

Hi all,

I've made a summary table of averages for different categories. I'm trying to create a measure that only adds certain rows of that table.

This is my attempt so far.

test =
VAR averageingtable =
SUMMARIZE(
        CaseHistory,
        CaseHistory[OPName],
        "AverageOpTime",
        [AvgOpFiltered]
    )
RETURN
CALCULATE(
SUMX(averageingtable,[AverageOpTime]/60),
[OPName] = "OP20" || [OPName] = "OP30"
)

The final line of code below returns an error as it doesn't recognise the row OPName from the summary table.

[OPName] = "OP20" || [OPName] = "OP30"

Is there any way to refer to the first column of the summary table I've created? Using CaseHistory[OPName] instead just sums up all the rows so is not an option.

Thanks

[antel1 · Accepted solution]

Found a solution in case anyone else has this problem.

test = 
VAR averageingtable = 
    SUMMARIZE(
		FILTER(
            CaseHistory,
            CaseHistory[OPName] = "OP20" || CaseHistory[OPName] = "OP30"
        ),
		CaseHistory[OPName],
		"AverageOpTime",
		[AvgOpFiltered]
	)
 RETURN
        SUMX(averageingtable,[AverageOpTime]/60)

I filtered the data before I calculated the table which did the trick.