Conditional Net Average

[Anonymous]

I have three measures Avg1, Avg2 and Avg3. I use these to compute a Net Avg which is basically the average of all three. 

Net Avg = (Avg1 + Avg2 + Avg3)/3

However, if on some days the Avg2 for instance is zero I would like to ignore it and then the Net Avg will be (Avg1 + Avg3)/2.

Similarly if on some days the Avg2 and Avg3 are both zeroes, I would like to ignore them and then Net Avg = Avg1.

Can't get my head around on how to achive this for all scenarios! Please help! Thanks!

[amitchandak · Accepted solution]

@Anonymous , Try measure like

divide([Avg1]+[Avg2] + [Avg3], if([Avg1]=0,0,1)+if([Avg2]=0,0,1)+ if([Avg3]=0,0,1),0)

[Anonymous]

Thanks that worked!