Average from Measure

Easiest way i can think of is this:

Average Rate1 = DIVIDE(
		[Percent Rate1] + [Percent Rate2] + [Percent Rate3],
		if(
			[Percent Rate1] > 0,
			1,
			0
		) + if(
			[Percent Rate2] > 0,
			1,
			0
		) + if(
			[Percent Rate3] > 0,
			1,
			0
		)
)

Hi there, I could suggest a modification to Anonymous measure.

Average Rate1 =
Var PercentRate1 = IF([Percent Rate1]>0,1,0)
Var PercentRate2 = IF([Percent Rate2]>0,1,0)
Var PercentRate3 = IF([Percent Rate3]>0,1,0)
Var PercentRates = PercentRate1 + PercentRate2 + PercentRate3

 DIVIDE(
		[Percent Rate1] + [Percent Rate2] + [Percent Rate3],
		PercentRates
)

This just uses variables and puts them into a logical order, and then makes it easier to change it or update it going forward.