SSAS 2008 - Duplicated calculated measure values

[nodoubtom]

We've got a couple cubes that have Invoice Line level data which includes an Item and Invoice Dollars.

There's an attribute of the Item dimension, a Y/N flag, that is used as a slicer in a calculated measure. Meaning that we only want Invoice Dollars for Items that have this flag set to N.

When I drill down to the Item level with the various Item Category hierarchies, I run into a problem of data that seems to be a sum of several Invoice Lines that then gets duplicated on multiple lines in the cube output.

When I compare the calculated measure to the base measure, I can see the Invoice Dollars and it seems like the calculated measure is the sum of multiple Items, but then there are even Items that have no Invoice Dollars that also show up with this calculated measure. The strange thing is that the subtotal for both the base and calculated measure are the same and equal the sum of the base measure.

Here's an example:

Item, Invoice Dollars (base measure), Finance Invoice Dollars (calculated measure)
A, 50, 125
B, 75, 125
C, ,125
D, 30, 30

SBTL, 155, 155

Any help is most appreciated!

Thanks!