Hi,

I'd like to add an average calculation to my cube.

My formula is: [Measures].[Grade]/[Measures].[Grade count]

This works fine but now I'd like to exclude every grade which is a 0.
How can I do that?

Thanks!

You can replace the count mesure with function count on a set, and use
the filter function to filter the grade with 0

Count(filter(set, [Measures].[Grade count] <> 0))

set is a set including all your members to count.


florian wrote: