在矩阵视觉中将总和值从总和值改为平均值(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] ) )更多推荐
发布评论