Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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 , Try measure like
divide([Avg1]+[Avg2] + [Avg3], if([Avg1]=0,0,1)+if([Avg2]=0,0,1)+ if([Avg3]=0,0,1),0)
Thanks that worked!