Filtering based on measure aggregation in cube based report

[Adam_Clone]

Hi all! My last post on Median calculation went without replies. I hope I will get replies on this one.

I need to implement a seemingly simple % calculation as follows:

% = (Count of categories with [Measure] value = 0 or [Measure] value missing) / (Total count of categories)

Can I do this directly in Report Studio?
Or should I have the numerator and denominator pre-calculated in the cube and simply do the percentage calculation in the report ?

[MFGF]

You can do either.

If you want to calculate it in the report, you could use an expression such as

count([Measure] within set filter([your level or set of members], [Measure] = 0 or [Measure] is null)) / count([Measure] within set [your level or set of members])

Cheers!

MF.