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

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