Search code examples
powerbidaxpowerbi-datasource

Average gives incorrect number Power BI Desktop

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

enter image description here

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.

What am I missing?

enter image description here

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.

enter image description here

Solution

  • 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.