Display Total Sum and Average but for one column value

[Anonymous]

Hi,

I have requirement to display both Sum and Avg as total for same value in Matrix without displaying the value in two columns. Please find the screenshot what I am getting and  I would need to acheive. I found one solution to reduce the size of unwanted column, but would like to know is there any better solution as part of latest release. Please advise. 

Average and sum 

[v-xuding-msft]

Hi @Anonymous  ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

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.

[v-xuding-msft]

Hi @Anonymous ,

For your pic1, I think you get the results using the function of AVERAGEX. If so, you could just remove the values of ID. The Averagex function will just calculate the total column. The original columns will still show the values of ID like below.

Avg = AVERAGEX('Table',SUM('Table'[ID]))

If you still want to show the column name "ID", you could create a new table manually and put the column into Column field of the matrix. Please follow the steps to have a try.

• Create a new table manually 

For more details, please see the attachment below.

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.