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 categ...
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

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



    • Ritaf1983's avatar
      Ritaf1983
      Super User
      3 years ago

      Glad to help 🙂