Forum Discussion

RuthMerchán's avatar
RuthMerchán
Helper I
3 years ago
Solved

Add 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 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!

 

 

Need Help
Show and Tell
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    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

3 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    3 years ago

    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's avatar
      RuthMerchán
      Helper I
      3 years ago

      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! 🙂