在矩阵视觉中将总和值从总和值改为平均值(change the value of the Grand total from sum of values to average in the matrix

在矩阵视觉中将总和值从总和值改为平均值(change the value of the Grand total from sum of values to average in the matrix visual)

我有一个像这样附加的矩阵视觉。 有什么方法可以将总计更改为平均值？

即使在表格视图中，我仍然只有总值，而是希望平均值出现在我的表格末尾。

有什么建议可以实现这个目标吗？

PS：我不想在矩阵或表格中改变我的值来改变平均值然后求和。

I have a matrix visual like this attached. Is there any way I could change the grand total to the average value?

Even in the Table view, I still have only the total value, instead, I want the average value to be present at the end of my table.

Any suggestions to get achieve this, please?

PS: I don't want to change my values inside the matrix or tables to change to average and then sum it.

最满意答案

这可能有助于：

Value = IF ( HASONEVALUE ( YourTable[athlete] ), SUM ( YourTable[Energy] ), AVERAGE ( YourTable[Energy] ) )

This might help:

Value = IF ( HASONEVALUE ( YourTable[athlete] ), SUM ( YourTable[Energy] ), AVERAGE ( YourTable[Energy] ) )