I have a calculated measure performing some mathematical equations to the data.

Basically the results are something like

ColumnA ColumnB CalculatedTotal
2,000,000 160,000 .7
2,500,000 190,000 .8
=========
.12
The problem is that it appears that the calculated measure sums the data
before doing the calculations resulting in a wrong value (or at least not
what I want).
What I want is to have an AVERAGE for the rollup and get a result of .75 in
this case. Is there a way to override this behavior?

Hi steve,
which is the formula that u are using? did u use SOLVE_ORDER ?

"SteveM" <SteveM (AT) discussions (DOT) microsoft.com> wrote

I looked at that, but I don't think it solves my problem.

I think what is complicating this is that the values in "A" and "B" columns
below are treated differently based upon a dimension with account types. Some
members are percentages, others Last child, others are summed.

However, once the calculated total is created , I want these to simply
average.

The calculated measure is below. It references a couple of other measures,
but it is working for the details. However, it gives the wrong answer for the
total.

IIF ( ISEMPTY([Measures].[WarningN]) OR ISEMPTY([Measures].[ValueN]) OR
ISEMPTY([Measures].[TargetN])
,
NULL,
Case
When [Measures].[WarningN] = [Measures].[ValueN] then .75
When [Measures].[WarningN] < [Measures].[TargetN] then
case when [Measures].[ValueN] > [Measures].[WarningN]
then (.75 + (( [Measures].[ValueN] - [Measures].[WarningN]) /
(([Measures].[TargetN] - [Measures].[WarningN])*10)))
else (.75 - (( [Measures].[WarningN] - [Measures].[ValueN]) /
(([Measures].[TargetN] - [Measures].[WarningN])*10)))
end
else
case when [Measures].[ValueN] > [Measures].[WarningN]
then (.75 - (( [Measures].[ValueN] - [Measures].[WarningN] ) /
(([Measures].[WarningN] - [Measures].[TargetN])*10)))
else (.75 + (( [Measures].[WarningN] - [Measures].[ValueN] ) /
(([Measures].[WarningN] - [Measures].[TargetN])*10)))
end
end)




"Mariana" wrote:

I think that u must ask for isleaf(dimension1.currentmember.children) for
each dimension with "AND" operator and then it's a leaf use your formula, if
not u must use something like this:
avg(dimension1.currentmember.children,dimension2.c urrentmember.children,...,Measures.CalculatedTotal )
(autorefering)

"SteveM" <SteveM (AT) discussions (DOT) microsoft.com> wrote