Combining SUM and AVERAGE in one matrix

[Joe_100]

Hi,

I have the following data.

Indicator	Value	Month
T1	100	1
T2	200	1
T3	2	1
T1	150	2
T2	190	2
T3	5	2
T1	250	3
T2	300	3
T3	8	3

I want to show this in a matrix and summarize the data for T1 and T2.

T3 needs to show an average.

What i now do is creating a measure where i sum everything except T3. And creating a seperate measure and take the avg of T3.

In another measure i do the following "SUM measure + AVG measure" and add it to the matrix.

This is working fine, it shows the sum of T1 and T2 seperate and shows the AVG of T3.

But i was thinking, is there not an easier way?

Thanks!

[Joe_100 · Accepted solution]

Think i found a normal solution.

Using the switch statement 🙂

measure =
SWITCH(VALUES(Table[Indicator]);
"T1";SUM(Table[Value]);
"T3";SUM(Table[Value]);
"T3";AVG(Table[Value]))

[v-chuncz-msft]

@Joe_100 

Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.