none
Distinct Count

    Question

  • Hello,

    I am trying to count distinct customers(Cust_cd) in my cube. I created calculated measure

    DistinctCount([Customers].[Cust_cd].members)

    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.

    Thursday, August 22, 2013 12:22 AM

All replies

  • 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>

    Thursday, August 22, 2013 12:41 AM
  • 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.

    Thank you!

     

    Friday, August 30, 2013 4:39 PM