Forum Discussion

Jebilaya's avatar
Jebilaya
Helper III
4 years ago
Solved

Row total within Matrix

Hi

 

I have a matrix table which is calculating average driver ratings of scores but I want to also include a column that just has the total number of results that have gone into the average.  Any ideas?

 

Screen shot below

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Jebilaya ,

     

    If you just want to change the column total in matrix visual, please try:

    Change Total = IF(HASONEVALUE('Table'[Date]), FORMAT( [Percentage] ,"0.00%"), FORMAT( [Sum], "##"))

    Since the percentage measure and sum measure are in different formats——Decimal Number type with % and Whole Number type, I used FORMAT() to custom the display format. So in this case, the measure returns Text type.

     

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Jebilaya , You can replace the total with another total, I doubt you can add another one

     

    if(isinscope(Table[Month]), [Measure], averageX(Values(Table[Month]), [Measure]) )

  • Jebilaya's avatar
    Jebilaya
    Helper III
    4 years ago

    Thanks for your response amitchandak 

    I can add a measure that allows the number of results  but it puts it in for each period as well, but I just want it for the total

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Jebilaya ,

     

    If you just want to change the column total in matrix visual, please try:

    Change Total = IF(HASONEVALUE('Table'[Date]), FORMAT( [Percentage] ,"0.00%"), FORMAT( [Sum], "##"))

    Since the percentage measure and sum measure are in different formats——Decimal Number type with % and Whole Number type, I used FORMAT() to custom the display format. So in this case, the measure returns Text type.

     

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.