Change matrix total to show different options - sum, count or average.

[Anonymous]

I have a matrix that look at employee hours by pay period. Is there a way to have different options in the Total column? I would like to have the sum in rows 1 through 4 and the average in rows 5 and 6.

[parry2k]

@Anonymous you can put conditions in your measure based on which row you are on: something like this, tweak switch function as per your requirement.

Measure = 
SWITCH ( SELECTEDVALUE ( Table[Row] ),
"Sum Sales", SUM ( Table[Data] )
"Avg Sales", AVERAGE ( Table[Value] )
)

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[Anonymous]

I guess that would work but I am simple in nature - I was hoping for a way to select sum, count or average in the Format Roller, Subtotals, Row subtotals. Hopefully in the near future Microsoft will add this function. Thanks for your help. 

[Syndicate_Admin]

@Keltea in fact, we all want an easy and out-of-the-box solution, let's never stop adding them as an idea in the ideas forum and helping to improve the product. Bless you!!

[parry2k]

@Anonymous indeed, we all want easy and out of box solution, never stop adding these as an idea on ideas forum and help improve the product. Cheers!!