Hi
I was calculating averages as

IIF(Not IsLeaf([Product].[Category].Currentmember),AVG([Product].[Category].currentmember.children,[Measures].[RS
SAI test]),[Measures].[RS SAI test])

it also includes count of member which are blank or 0
How can i avoid it doing so

I tried doing
IIF(Not IsLeaf([Product].[Category].Currentmember),Colesceempty(AVG([Product].[Category].currentmember.children,[Measures].[RS
SAI test]),0),[Measures].[RS SAI test])

but still doesn't work

how to do this