Forum Discussion
Adding Average column on Matrix Subtotals
Hello PowerBi experts !
I need your help. On a matrix, I want to display the sum of quantities (as shown below) and in a last column, the average of these values.
I can not do this, I only can display sum of quantities and the grand total of sum.
I want to keep sum of quantities (not showing avergae on all datas).
Can somebody help me ?
Example of average calculation: for REF_A, sum is 34744, average would be: (4638+4136+70+1744+2625+1376+1553+1828+1548+2280+1612+1460+3800+2392+1080+1380+1222)/(17) = 2043.76
In other word, the formula should be the Sum of Quantity / Number of Months of my field "Date"
1 Reply
hi, Vincent_
According to my knowledge, I'm afraid that it is not available to achieve add a custom column on Matrix Subtotals for now.
And you may drag an average measure into Value, now it will appear an average Subtotal each row. Then decrease the size of the columns until they are hidden. Like in excel in the middle of two colums you can resize them as below post:
https://community.powerbi.com/t5/Desktop/Hiding-in-matrix/m-p/705026#M340327
Best Regards,
Lin
