Incorrect Average Result

[Mourt]

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

[vanessafvg · Accepted solution]

values ignores blanks, it would be best to set those blank values to 0 or use distinctcount which counts blanks