Add AVERAGE TOTAL ROW in a matrix

[RuthMerchán]

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 category A and B. Furthermore, I would like to have to the right of this total, the average total. I mean 18,25 and 26,66 for category A and B, respectively.

Is this possible?

Thank you for your support!

[Ritaf1983 · Accepted solution]

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]))

Link to sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[RuthMerchán]

Hi @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:

Thank you for giving me some idea! 🙂

[Ritaf1983]

Glad to help 🙂