Forum Discussion

antel1's avatar
antel1
Frequent Visitor
7 years ago
Solved

Adding Certain Rows from a Summary Table

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

 
Need Help
  • antel1's avatar
    antel1
    7 years ago

    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.

1 Reply

  • antel1's avatar
    antel1
    Frequent Visitor
    7 years ago

    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.