Hello,

I am trying to generate a member set with the members
from the entity dimension whose property "Owner_Type"
value is equal to "Owned". Then after i produce the
member set apply a sum function.

I got an error when i tried to create this member set by
using the following MDX calculated member:

Calc_Member = FILTER([Entity].Members,
[Entity].CurrentMember.properties("OWNER_TYPE")="Owned")

it gives me this error:"Cannot convert set to Expression
in the filter function"

any ideas will be very apprecitated

thanks

Something like so. Replace "My Measure".

SUM(FILTER([Entity].Members,
[Entity].CurrentMember.properties("OWNER_TYPE")="Owned"),
Measures.MyMeasure)

public @ the domain below
www.tomchester.net

"martino rivaplata" <anonymous (AT) discussions (DOT) microsoft.com> wrote