Forum Discussion
RuthMerchán
Helper I
Helper IAdd AVERAGE TOTAL ROW in a matrix
Hi everyone! I would like to know if possible to add an average total (included sum total) to the right of the following matrix? As you can see, we have total sum 73 and 80 for categ...
Hi RuthMerchán
You can manipulate your totals with functions as is filtered/hasonevalue/isinscope etc.
Example :Test = if (ISFILTERED('Table'[Sub Category]),sum('Table'[Value]),AVERAGE('Table'[Value]))If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
RuthMerchánHelper I
Helper IHi Ritaf1983 ! As I was interested in showing not only total sum but also total average, the formula that helped me was the following:
Promedio_Semanal =
IF (
ISFILTERED(DIM_TIME[DAY_DESC]),
BLANK(),
AVERAGEX (
VALUES(DIM_TIME[DAY_DESC]),
[VALUE]
)
)
So, I got this result, without show average also for each day:
So, I got this result, without show average also for each day:
Thank you for giving me some idea! 🙂
Ritaf1983
Super User
Super UserGlad to help 🙂