Hi ,
When we are using Count Distinct for a measure , and using the measure in A cross table, the sum for the count distinct is for all table and not the different categories .
For example, a table with Males and Females
The Total count distinct will be for all ( Male + Female ) and will be total of 19 .
But in the table (F, M) you will have more cases. lets say 9 females and 11 males.( One Female is also a Male ) .
I want the ability to show Total of 20 using only the count distinct measure
gender countdistinct count
M 10 10
F 9 10
TOTAL 19 20
Is it possible?
