I am trying to compute an average of a measure whose values exceed
zero.

Logically,

sum(values that exceed zero)/(sum(number of values that exceed zero).

I can get an average with this, but it does not filter out zero values.

[Measures].[ValueToAverage]/[Measures].[Quantity]

I keep getting syntax errors when I try to restrict the values down to
non zero values.

([Measures].[Remaining Step Count]/[Measures].[Quantity])
FROM CompletedStep
WHERE ([Measures].[Remaining Step Count] > 0)

I've also tried the avg/filter expression

AVG(Filter([Measures].Members,[Measures].{Remaining Step Count] >
0),[Measures].[Remaining Step Count])

If anyone can help me understand what I'm doing wrong would appreciate

Try with IIF statement

"Tiger Tail" wrote:

Would it be possible to seea working example using iif?

Thx

Kalyan wrote: