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 (AT) discussions (DOT) microsoft.com> wrote

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 (AT) discussions (DOT) microsoft.com> wrote