Forum Discussion

Jebilaya's avatar
Jebilaya
Icon for Helper III rankHelper 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 ...
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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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]) )