Would it be viable to create dimension on times retreaded? You can filter by
measure but it will be easier to do i you create a dim and then filter by
it. Not to mention what does it mean = 1? Does it aggregate on diff levles?


MC


"Owen J." <OwenJ@discussions.microsoft.com> wrote in message
news:83731526-A244-46C1-BF5A-278337846895@microsoft.com...
>I have the following:
>
> A hierarchy named [Tire].[Tire Hierarchy] that contains a list of tires by
> tire manufacturer.
>
> I have two measures in the fact table:
> [Measures].[NRT Units]
> [Measures].[Times Retreaded]
>
> I need to create a sum of [NRT Units] for all tires at any level when the
> [Times Retreaded] = 1. Anyone have any suggestions?