Problems with Measure by DistinctCount

I have this problem:
Dimensions: Year, Month
Measure: CustomerCount (int)
I set CustomerCount.AggregateFunction=DistinctCount
When I filter Month Dimension I have a problem on agregate total.
For example:
Year Month
gen feb total
2001 100 103 err.
2002 230 234 err.
2003 300 280 err.
total 400 398 err.
This problem happens when I filter but If I remove filter I have correctly
totals.
What can I do?Here, total is not just sum of Jan and Feb.
I understand that current version does not support distinct count against
sube cube.
Ohjoo Kwon
"Dario Concilio" <DarioConcilio@.discussions.microsoft.com> wrote in message
news:39860F22-7B0A-4D7A-B828-DCE427C4A473@.microsoft.com...
> I have this problem:
> Dimensions: Year, Month
> Measure: CustomerCount (int)
> I set CustomerCount.AggregateFunction=DistinctCount
> When I filter Month Dimension I have a problem on agregate total.
> For example:
> Year Month
> gen feb total
> 2001 100 103 err.
> 2002 230 234 err.
> 2003 300 280 err.
> total 400 398 err.
> This problem happens when I filter but If I remove filter I have correctly
> totals.
> What can I do?|||to solve aggregation errors using a DCount measure, you have to use dynamic
distinct count measure.
Like
count(crossjoin(<my dimension>.<my level>.members, measures.<My measure to
count> ), excludeempty)
"Dario Concilio" <DarioConcilio@.discussions.microsoft.com> wrote in message
news:39860F22-7B0A-4D7A-B828-DCE427C4A473@.microsoft.com...
>I have this problem:
> Dimensions: Year, Month
> Measure: CustomerCount (int)
> I set CustomerCount.AggregateFunction=DistinctCount
> When I filter Month Dimension I have a problem on agregate total.
> For example:
> Year Month
> gen feb total
> 2001 100 103 err.
> 2002 230 234 err.
> 2003 300 280 err.
> total 400 398 err.
> This problem happens when I filter but If I remove filter I have correctly
> totals.
> What can I do?