Dear NG

We have a measure called Income. The user now wants to filter the result as
hereafter:

Example: Income is bigger than 1000 but smaller than 1500 $.

I know that measures can be filtered by select the dimensions. But is it
possible to
filter the returned result again?

Thanks for help

Mike

You can use the Filter() MDX function to do this. As the first argument,
give it the set of tuples to be filtered. As the second argument, define a
boolean expression that tests for the values you're interested in.

Eg. Filter( MyDim.MyLevel.Members, ((MyDim.CurrentMember, Income) > 1000)
AND ((MyDim.CurrentMember, Income) < 1500 ))

Hope this helps,
- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"mike" <michaelhenzi (AT) hotmail (DOT) com> wrote

Thanks Matt

It works fine. (How could I forget the current Member - shame on me).

Thanks
Mike



"Matt Carroll [MS]" <MattCar (AT) online (DOT) microsoft.com> schrieb im Newsbeitrag
news:ueUti5MlDHA.3256 (AT) tk2msftngp13 (DOT) phx.gbl...