I am trying to count distinct customers(Cust_cd) in my cube. I created calculated measure
which is able to display accurate count when used with other dimensions eg. product Heirarchy from Products dimension but when used with Customers Dimension it is showing the same count.
Thanks for help.
Could you explain your solution in more detail? If you use a DistinctCount with Customers, shouldn't each Customer count as 1? Or am I missing something?
<a href="http://martinsbiblog.spaces.live.com" target="_blank">http://martinmason.wordpress.com</a>
When I do distict count with the help of corp_cd which is in the customer dimension I get same values for every corp_cd.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?