平均值给出了不正确的数字 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屋！