Forum Discussion
Solved
Incorrect Average Result
Hi
I have a table that consists of 2 columns (Type,Value) there are some values that are blank means they are Zeros
I want to calculate the average of values including the blanks (ex Average of type A = (0.5+0.2+0)/3 not (0.5 +0.2)/2
I tried
AVERAGEX(SUMMARIZE(VALUES('Table'[type]),'Table'[type],"_value",AVERAGEX('Table','Table'[value])),[_value])
| type | value |
| A | 0.5 |
| A | 0.2 |
| A | |
| B | 0.8 |
| B | 0.1 |
| C | |
| D | 0.3 |
| E | 0.4 |
| F | 0.2 |
| F |
values ignores blanks, it would be best to set those blank values to 0 or use distinctcount which counts blanks
1 Reply
values ignores blanks, it would be best to set those blank values to 0 or use distinctcount which counts blanks