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 avera...
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.

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.