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