Average of a measure total(include null values)

[shravanreddy133]

Hi,

I have a measure which calculates the percentage for each Month.

How do i calculate the average of 'P3zerocomplaince'? For example : (100% + 100% +100% + 0 +100% +50% ) divide by 6 = 75%. 

I've tried using average and sumx  functions, but they give me 50% as results.

Any help is much appreciated. Thanks.

[amitchandak · Accepted solution]

@shravanreddy133 , Assuming P3zerocomplaince is a measure.

You can have a measure like

Avergaex(Values(Date[Month Year]), [P3zerocomplaince])

Use the correct table and column name for month year