Forum Discussion
Solved
Column subtotal sum row subtotal average
Dear All, I would need you support for the below issue : Basically the column subtotals are correct showing the sum of each row ... but for the row subtotal i would like average (at the mome...
Hi alexbalazsalex ,
You could create a measure with the functions of AVERAGEX and VALUES to implement it.
Here is my sample. Please reference it to modify yours.
Total sales = CALCULATE(SUM('Table'[Sales])) Avg = AVERAGEX(VALUES('Table'[Product]),[Total sales])Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sorry just a clarification as i made a mistake ... i would want column subtotal as average and row subtotal leave as it is as sum.
Thanks
