Forum Discussion
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 moment showing sum also there)...
IS that possible?
Many Thanks,
Alex
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.
4 Replies
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
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.
Many Thanks v-xuding-msft
Sometimes we tend to over complicate some things in our head .... very usefull & Gratefull for your feedback
Alex
