平均值给出不正确的数字Power BI Desktop [英] Average gives incorrect number Power BI Desktop

问题描述

我有两列包含OpenTasks和ClosedTasks的值，它们的值均为0或1。

I have two columns with OpenTasks and ClosedTasks, both have values either 0 or 1.

然后我使用按日期分组的矩阵，并希望获得每一列的平均值。
但是数字对我来说似乎不正确。 0.44和0.56
我尝试创建度量，但结果却相同。

Then I use matrix grouped by date and want to get an average for each column. But number seems incorrect to me. 0.44 and 0.56 I tried to create measure, but gives me the same result.

我想念什么？

更新：
在下面的图片中，我期望Sum（TotalTask​​s）/（每天总任务数）
，即：
2,818 / 10 = 281
那是平均水平，对吗？对不起，我很困惑。

UPDATE: On a picture below I'd expect Sum(TotalTasks)/ (Number of Total Tasks per day) which is: 2,818 / 10 = 281 Is that would be average, am I right? Sorry I'm confused.

推荐答案

在我看来，该衡量标准是平均每行级别的任务。我相信您希望将它们平均化。取任务总和，除以天数即可得出每天的平均计数。

It looks to me like the measure is averaging the task per row level. I believe you want to average them at the day level. Take the sum of tasks and divide by number days to get the average count per day.

这篇关于平均值给出不正确的数字Power BI Desktop的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！