How get Distinct Count

[jaggy99]

Hi All,

I have excel 2010 and have power pivot installed. I'm trying to get the distinct count of the product code per group but not able to. When I try distinctcount I get the error This is not a valid DAX expression. Not sure if distinctcount is available with the powerpivot for excel 2010.

Can you please have a look and let me know where I'm going wrong? I have my sample sheet upload here https://app.box.com/s/od5wftgpyjcs5ceej0ho37omqf90xlff


Thanks

 

[Weazel]

maybe something like...

=COUNTROWS(DISTINCT(Table2[Product Code]))