Row total within Matrix

[Jebilaya]

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

[Anonymous · Accepted solution]

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]

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

[amitchandak]

@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]) )